Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sparrow
Starting Member
20 Posts |
 Posted - 2008-02-18 : 21:54:42
|
| i have a package that runs fine till i add another connection and Transform data task. If i run execute the task individualy it runs fine, but when it is run as a scheduled job i get the following error Step Error Source: Microsoft Data Transformation Services (DTS) PackageStep Error Description:Need to run the object to perform this operation (Microsoft Data Transformation Services (DTS) Package (80040005): Need to run the object to perform this operation) (Microsoft Data Transformation Services (DTS) Data Pump (80040005): Code execution exception: EXCEPTION_ACCESS_VIOLATION)Step Error code: 80040005Step Error Help File:sqldts80.hlpStep Error Help Context ID:1100The rest of the package runs fineThis has happened before when adding these tasks, but i got a contractor to have a look and they fixed the problem. Unfortantly i didn't find out what they did and now they are no longer with us |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-18 : 22:56:20
|
| What does the step do? Any remote data source involved? |
 |
|
|
sparrow
Starting Member
20 Posts |
Posted - 2008-02-18 : 23:09:59
|
| it takes data from a view (in a object based aplication) and populates a table with in a sql data base there are about 50 steps all doing the same thing. I've had a look at the properties of the steps that work and can't see any differences. Another thing is that sometimes it the job will run fineWondering if it could be something to do with it trying to run the steps at the same time??Cheers |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-18 : 23:24:25
|
| You can enable package logging, that'll tell you what's the problem. |
|
|
|
albertlung
Starting Member
1 Post |
Posted - 2008-03-04 : 19:38:25
|
| I was having the same problem. But I was able to resolve the issue by doing the following...to run the dts package, you must physically login to the sql server which hosts the dts package and you cannot just use EM and remote connect to the server. Once you are login to the server, open the EM and the dts package. Check the package database connection and make sure it is "local" instead a server name. Also check the path of the source file, make sure it is in unc format such as \\myserver\upload (try not use the ip address such as \\10.1.1.100\upload). Once you have done the following changes, you should be able to run dtsrun with source file from any server... Albert |
|
|
|
|
|
|
Error with DTS