Timtropolis
Registered User.
- Local time
- Today, 09:46
- Joined
- Jun 17, 2004
- Messages
- 84
Greeting all.
I have a question regarding an error I'm receiving when running an SSIS package that xfers data from a flat file to an 2003 Access db.
SSIS is able to find the flat file and recognize it. Also, SSIS is able to connect to the database using OLE DB (see attachment 1).
There is a Stored Procedure in a SQL 2005 database that is used to process the data, however when this is called from the SSIS package, I get the error "The Microsoft Jet database engine cannot find the input table or query 'pr_fps_SSB_ImportFundCreateRequest" (see attachment 2 for screen shot of error)
Are Stored Procs not able to work with Access??
Any help would be greatly appreciated
TIA,
Tim
I have a question regarding an error I'm receiving when running an SSIS package that xfers data from a flat file to an 2003 Access db.
SSIS is able to find the flat file and recognize it. Also, SSIS is able to connect to the database using OLE DB (see attachment 1).
There is a Stored Procedure in a SQL 2005 database that is used to process the data, however when this is called from the SSIS package, I get the error "The Microsoft Jet database engine cannot find the input table or query 'pr_fps_SSB_ImportFundCreateRequest" (see attachment 2 for screen shot of error)
Are Stored Procs not able to work with Access??
Any help would be greatly appreciated
TIA,
Tim
Attachments
Last edited:
