I just simulated your example on our servers and noticed a couple of things. First, make sure the "xp_cmdshell" option is enabled on the SQL2005 box. Second, take...

At what point is the Dynamic Property task being run in the package? In most cases you'll want that task to run first.

A Microsoft evangelist recently mentioned in a meeting that licensing is on a per-socket basis, not per processor, so you should run into no licensing issues as long as you...

Do you have the XML definition file created? If so, what type?

I agree. Remember that SQL2000 DTS is more like ELT than ETL. In the past I've loaded the table into a temp and used a series of strings/substrings...

I know this post is late in the game, but it is mainly "food for thought" for those struggling with suspect databases in the future. "Suspect" can also appear...

Not to blame the developers, but if they are writing possibly suboptimal SQL statements directly into code as opposed to using stored procedures, you may miss the statements if only...

One thing you can try is sticking message boxes with the variable value in areas where you have questions. Comment the code underneath it out so that it doesn't...

Make sure you're using a UNC path to access the files when running the DTS package under your account instead of a mapped drive.

Have you tried a "select into" statement? Seems to work well. All you have to give is a table name. For subsequent running of a select into...

The only way I know to use/access extended DTS objects is through the use of ActiveX scripts.

Well, there seems to be a number of ways to do it. I've gone with importing the table names into a table in tempdb, rummaging through them for the...

I also agree with Greg and Remi. You can create a DTS package that uses a select into statement. Then you can transform the data as needed and...

I know this is ignorant sounding, but did you change the connection string from [local] to the new SQL box?

I received my first issue of Database Daily Update today and enjoyed it very much. Keep up the great work-I look forward to future issues!!!