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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DTS Problem

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-12 : 09:33:18
ants writes "A developer created a DTS package and executed it to see that it ran ok. It worked great.
Then he created a job to run the DTS package.
When he tried to run the job it failed with :

Error Code: 0
Error Source = Microsoft Data Transformation Services (DTS) Package
Error Description: The parameter is incorrect.
Error in line 4
The step failed.

I executed the DTS package from my workstation, with my username and the package worked great.
I tried running the job and received the same error message.

I then logged onto the server with my username and tried to open the
package.
I got the following error message:

Paccage Error:
Error source: Microsoft Data Transformation Services (DTS) Package
Error Description: The parameter is incorrect.

My username is a member of the NT administrators group and it has SQL SERVER system administrator privilege.

What is the problem ?
Thanks,
Ants."
   

- Advertisement -