August 2, 2005 at 8:10 am
This is the error message my friend gets:
Step 'DTSStep_DTSDataPumpTask_1' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:Column name 'SecurityType' was not found.
Step Error code: 80042008
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0
When I run the same DTS package, importing the same data file, I don't get this message, the package executes without errors. I can only assume it's some SQL Server setup difference, but don't know where to start looking, any ideas?
I have checked and the column referred to is there in both the file and the table being imported to.
August 3, 2005 at 11:55 am
More details would be helpful. However, the first thing to keep in mind is that when you run a DTS package (regardless of where the package is stored) it executes on the local machine. So, differences in the setup or permissions, from one machine (or user) to the other are the most likely explanation.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 9, 2005 at 11:43 am
shot in a dark: check MDAC versions
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply