DTS Package Failing

[ashleybyrdnc]

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.

 

[mrdenny]

It can't find the table [Cimpro].[dbo].[APCOPAF] on which ever side the table should be.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog