General information
Forum:
Microsoft SQL Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only