February 17, 2011 at 1:56 pm
Hello all,
I have a problem in scheduling my ssis package.
Info regarding my package:
My ssis package connects to ftp and get the files and loads in to a table.
I am using a sql login to execute this package.
When I run this package, It executes. But when I schedule a job, it fails.
Based on my research
If I use a windows login, the package executes normally (both schduled and manual)
But If I use sql login, the package fails when scheduledonly and runs manually.
So I tried to secure the package by setting protection level to 'Encrypt sensitive with password'
and tried to schdule the job..... it still doesnt work.
The error I get is:
Message
Executed as user: Started: 1:59:00 PM Error: 2011-02-17 13:59:01.32 Code: 0xC0202009 Source: abcd Connection manager "server.database.login" Description: SSIS Error Code DTS_E_OLEDBERROR. 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 'login'.". End Error Error: 2011-02-17 13:59:01.32 Code: 0xC020801C Source: Get data OLE DB Destination [9] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "server.database.login" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. ... The package execution fa... The step failed.
February 17, 2011 at 2:20 pm
striker-baba (2/17/2011)
My ssis package connects to ftp and get the files and loads in to a table.I am using a sql login to execute this package.
When I run this package, It executes. But when I schedule a job, it fails.
Based on my research
If I use a windows login, the package executes normally (both schduled and manual)
But If I use sql login, the package fails when scheduledonly and runs manually.
Message
Executed as user: Started: 1:59:00 PM Error: 2011-02-17 13:59:01.32 Code: 0xC0202009 Source: abcd Connection manager "server.database.login" Description: SSIS Error Code DTS_E_OLEDBERROR. 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 'login'.". End Error Error: 2011-02-17 13:59:01.32 Code: 0xC020801C Source: Get data OLE DB Destination [9] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "server.database.login" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. ... The package execution fa... The step failed.
Is the error message actually verbatim, or did you swap out the login name?
What windows account is SQLAgent running under? Does it have access to the locations in the connections?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply