DTS Package Error

[itsmarkdavies]

I keep getting an error message when running a DTS Package. Only 1 Step out of 8 fails, and the failing Step does nothing apart from create an index on a table using T-SQL. Has anyone had similar problems, or can anyone tell me what is going wrong ?.

The index builds quite happily if I grab the T-SQL and run it from Query Analyzer.

Please find full Error Text below :-


Step 'DTSStep_DTSExecuteSQLTask_2' failed
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0


itsmarkdavies@hotmail.com

 

[JayKusch]

Have you tried dropping and then recreating the failing step? From what I see in the error, it is a network issue that is causing the step to fail. Check to make sure the step is targeting the correct server/database/table and such.

Thanks

J. Kusch