May 19, 2010 at 10:23 am
Hi,
I am trying to import 1 table from a Server running SQL Express 2005 to a server running SQL 2005 using SSIS. I have setup the connections and the table links etc and can even preview the data on the source (SQLExpress box) but when I run the job in SSIS I get the following error:
SSIS package "LoadingSystemImports 1.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Error: 0xC0202009 at LoadingSystemImports, Connection manager "192.168.13.222\sqlexpress.Weighbridge.appuser": An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'appuser'.".
Error: 0xC020801C at Data Flow Task, Source - tblTicket [1]: The AcquireConnection method call to the connection manager "192.168.13.222\sqlexpress.Weighbridge.appuser" failed with error code 0xC0202009.
Error: 0xC0047017 at Data Flow Task, DTS.Pipeline: component "Source - tblTicket" (1) failed validation and returned error code 0xC020801C.
Error: 0xC004700C at Data Flow Task, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "LoadingSystemImports 1.dtsx" finished: Failure.
The program '[1696] LoadingSystemImports 1.dtsx: DTS' has exited with code 0 (0x0).
I know the username and password is OK as I can test the connection and preview data but it still fails
Please advise
Jason
May 19, 2010 at 11:53 am
Are you running this interactively from the BIDS designer, or have you deployed to the server and running it from there? If it's the latter, how have you set the protection level of the package?
May 19, 2010 at 1:01 pm
Hi
Thanks for reply. I am just trying from BIDS at this point
Thanks again
May 20, 2010 at 10:32 am
For anyone who is interested. I recreated this from scratch in BIDS. I had originally created the package in SSIS and then imported it into a project. This time I created it from scratch in BIDS and it worked fine
Hope this helps someone
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply