Jones,

You could create stored procedure(s) that can handle the logic of update/insert and make a call to the sp from your DTS package.

The only other option I can think of...

Aru,

We have a similar situation here. Our solution was to apply SP4 to SQL 2000 and use the SQL_Latin1_General_CP850_BIN2 collation setting on the database. We discovered some issues using other...

You could create a control DTS package which would call each import package and then check the results. If it (the child) doesn't complete successfully you can then re-run it...

I have always thought of this forum as a place where you help if you can and learn if you can't!! That is probably why I am always monitoring and...

I am in agreement about Case Sensitivity!! Unfortunately I work with a group that needs to be able to handle Unicode data from around the world and we provide some data...

You will need to make sure you have the proper Oracle client tools on the machine you are trying to run DTS from.

And as Remi pointed out - the time depends...

Brian is correct, and there are some issues with overall performance (and consistency) using the filesystemobject this way. But it is always an option when all else doesn't seem to solve...

Now there is one meeting were I would love to have been a "fly on the wall"!!!!!

Darrell

sushila,

You are welcome for the comments!

Mark,

You could try this query:

select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE

Good Luck,

Darrell

Saw an article once (and can't remember if it was on this site or not - gotta love senior moments ) about using the...

I don't have a good book to recommend (at least not yet ) but here is a good site to start with:

http://www.sqldts.com/

I have never worked with a BBF file before but I have imported some Foxpro data. If it is truly a Foxpro database you should be able to create an...

Markus,

Take a look at this link,

http://support.microsoft.com/?kbid=891201&SD=tech

Good luck,

Darrell

Brett,

Take a look at this link - it should answer your questions.

http://www.sqldts.com/default.aspx?215