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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS Package Failing

Status
Not open for further replies.
Joined
Oct 23, 2007
Messages
36
Location
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top