Only Dev has SP2 applied but I will have network applied to production and QA.

Thanks,

Ed

When I originally moved the packages, I had to edit them and I was able to. I didn't have problems with connections to servers because, since all transactions were going...

Only my dev server has SP2 but they used to work before in this server.

Ed

No, the new server we are migrating too only has 2005 installed.

Hi Tommy,

I did so.

Regards,

Ed

The errors that I get are the following:

First:

Error Source : Microsoft Data Transformation Services (DTS) Package

Error Description : The DTS host failed to load or save the package properly.

Second:

The selected...

After I removed that row from the text file, it worked and went all the way to the end. The delimiter they were using was |.

Thank you all,

ED

John,

I checked the file and the row next to the last one loaded has the delimeters out of whack. I deleted that row and I am reruning the process. ;)...

It's the last 1656. It seems to get to that point and just give up.

Ed

The text file is delimited and it doesn't user a format file or bulk insert.

Thanks,

Ed

The jobs run a DTS package but it's in the performance stored procedure that the main one gets stuck. The other one I run it directly from DTSDesigner because it...

The 😀 job completed after 26 hours so there is no urgency to this anymore but I am still curious if it can be done.

Regards,

Ed

Thank you all, the problem we were having was due to a difference of about a minute between the middle tier server and sql server. They were running a minute...

Thanks, Andras, I will look into this option.

Ed

Hi Chirag,

I moved backups from the 2000 server and restored the databases to the 2005 server. I did reindex and ran update statistics. I don't know about the .net connections...