Home > Archive > MS SQL Server > March 2006 > problem with dts packages on two servers









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author problem with dts packages on two servers
Dan D.

2006-03-09, 1:23 pm

I have two SS2000 boxes and I'm trying to get a dts package on server1 to run
a dts package on server2. When I execute the package task on server1, I get
an error that says step 1 in the dts package on server2 failed. It says
invalid object name and gives the name of the table that the package is
processing.

I can go to server2 and run the dts package and it completes successfully.

Any ideas?

Thanks,
--
Dan D.
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com