×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

DTS Package Failing

DTS Package Failing

DTS Package Failing

(OP)
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.  

RE: DTS Package Failing

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close