June 10, 2008 at 8:05 am
I created a SSIS package (using Transfer SQL Object Task) to replace data of some tables from one database to another (both databases have the same structure), but I got the following error from connection manager when I used user 'sa'. The problem is that the password is not saved. Any solutions?
[Connection manager "BART.MyDBName.sa"] Error: 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 'sa'.".
Thanks.
--------------------------------------------------------------
DBA or SQL Programmer? Who Knows. :unsure:
June 10, 2008 at 8:13 am
You would have to EncryptSensitiveWithPassword.
Personally, my eyes would be popping out of my socket the moment someone tells me they cant do anything with sa, because why are you using the sa user to start off with?
Do you not have authentication set up into your machine? What is your long term plan with your SSIS job (i.e. are you going to migrate this to another environment)?
Sorry, but sa is off limits any given day, even on my localhost, I leave that for administration purposes.
~PD
June 30, 2008 at 11:25 pm
Hi,
I too get the Same Error..but i have run it with a different account.
Please help me in handling this out.. really my works are hanging.. halfway....
July 1, 2008 at 2:33 am
July 1, 2008 at 8:04 am
Check this out:
http://forums.microsoft.com/Forums/ShowPost.aspx?PostID=3491777&SiteID=1&mode=1
--------------------------------------------------------------
DBA or SQL Programmer? Who Knows. :unsure:
October 13, 2009 at 2:23 pm
This article answers your question and yes..I realize this thread is over a year old.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply