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.