Hi,

I had a job on a server with SQL 7.0 SP3 and Win NT 4.0 SP6. The job only reads a text file and transfers the data in a table. In the text file, there is a date with this format MM/DD/YYYY. It gets transfered to the database with format YYYY-MM-DD. This works.

I tried to recreate that job on a new server with SQL with SQL 7.0 SP3 and Win 2000 SP2. When I ran the DTS, the date got converted improperly. Thus, if the input was 07/01/2002(July 1, 2002), the output was 2002-01-07(January 7, 2002). Therefore there is a problem with the date conversion. I looked at the regional settings and they are both the same. Are there any other settings (for SQL Server or Windows) which I should look at?

To work around this problem I decided to convert the data into dates using the transform DTS: DateTime String (instead of a direct transfer of data). I ran the DTS manually on the new server using Enterprise Manager (SQL7.0 SP3 & Win 2000 SP2) and it converted properly. I got the dates I wanted and everything was fine. However, when I scheduled the job with SQL Agent it failed with the following error:

DTSRun: Loading... Error: -2147221005 (800401F3); Provider Error: 0 (0) Error string: Invalid class string Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 713. Process Exit Code 1. The step failed.

What's the problem? How can I correct this?

Dave Sonier
Technologies Nter