batch file that runs dts keeps getting error

[rsbutterfly16]

hi guys, i have a dts in which just copies tables from one database to another. If i run it mannually from EM i get no errors. I did a batchfile getting the command line from dtsrunui and it worked perfectly for a long time. but now i keep getting this error mesage:

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Catastrophic failure

Step Error code: 8007FFFF
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100


any ideas why this is happening? i checked security and permission but every is the same. help please.

 

[mrdenny]

When you are running the file in Enterprise Manager are you running it from your workstation or from the servers console (either on the console is self or via RDP, VNC, etc)?

What happens when you execute the package from the command line on the server's console?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[rsbutterfly16]

hi thanks for your reply, yes i am running it by my workstation, i also tried running the command line from the server's console and i get the same error...