Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS Packages

Status
Not open for further replies.
Oct 23, 2007
36
US
I was able to import my tables into MS SQl 2005 and they will drop and create. When when I try to run them again on a schedule they will not work. Nor can I run them manually agian. But everytime I reimport them they work the first time. here is my error log. Can anyone please help me.

Date 11/10/2009 1:42:50 PM
Log Job History (APCOPAF)

Step ID 1
Server CLR-CRYSTAL
Job Name APCOPAF
Step Name APCOPAF
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: COLORTECH1\superpet. ...t: Drop table [Cimpro].[dbo].[APCOPAF] Step DTSRun OnFinish: Drop table [Cimpro].[dbo].[APCOPAF] Step DTSRun OnStart: Create Table [Cimpro].[dbo].[APCOPAF] Step DTSRun OnFinish: Create Table [Cimpro].[dbo].[APCOPAF] Step DTSRun OnStart: Copy Data from APCOPAF to [Cimpro].[dbo].[APCOPAF] Step DTSRun OnError: Copy Data from APCOPAF to [Cimpro].[dbo].[APCOPAF] Step, Error = -2147217865 (80040E37) Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'APCOPAF'. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147217865 (80040E37); Provider Error: 208 (D0) Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'APCOPAF'. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: Copy Data... Process Exit Code 1. The step failed.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top