Dear All!

I am posting this because I am stuck and don't know what else to do so hopefully
you guys can help me out.

I have SQL Server Enterprise Manager 7.0 running on my server and I have
created a Local Package which I have scheduled.

SQL:
DTSRun /~S 0x36698CA36510CE7649A2497D0AFDF703BCEF590770891317 /~N 0xC71D8A58FF1A1B4B7F313719E84416F0C0A233258E2E4717A2FE75A53C0AD598
/E

However when the schedule runs the package I get this error.


DTSRun: Executing... DTSRun OnStart: Copy Data from famgrp to [MAV-DB].[dbo].[famgrp]
Step DTSRun OnStart: Copy Data from mmiss to [MAV-DB].[dbo].[mmiss] Step
DTSRun OnStart: Copy Data from uzdepd to [MAV-DB].[dbo].[uzdepd] Step
DTSRun OnStart: Copy Data from uzdload to [MAV-DB].[dbo].[uzdload] Step
DTSRun OnStart: Copy Data from uzdtxt to [MAV-DB].[dbo].[uzdtxt] Step
DTSRun OnError: Copy Data from famgrp to [MAV-DB].[dbo].[famgrp] Step,
Error = -2147008507 (80074005) Error string: Unspecified error
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp Help context: 1100 Error Detail Records:
Error: -2147008507 (80074005); Provider Error: 0 (0) Error string:
Unspecified error Error source: Microsoft Data Transformation Services
(DTS) Package Help file: sqldts.hlp Help context: 1100
Error: -2147467259 (80004005); Provider Error: 160 ... Process Exit
Code 1. The step failed.

Any ideas what this is or what is caused by?

I would appreciate some help on this.

Please email me!

Simon

stockton@covntry.ac.uk