April 9, 2009 at 8:26 am
My SSIS package uses EXPRESSIONS which reference Package.Variables in my dtsConfig file.
Using Package.Variables (in my dtsConfig file) and Variables and EXPRESSIONS in my SSIS Pkg, I successfuly set my SQL ServerName and SQL DBName (InitialCatalog) with no issues.. I cannot find an EXPRESSION to setup for the 'sa' PASSWORD???
When I highlight my Connection Manager(s) entries and look at the PROPERTIES for a given connection, I cannot determine how to setup an EXPRESSION and wire it to the SQL Login 'sa' PASSWORD.
Yes, there's an option to enter the PASSWORD for the Connection Manager on the PROPERTIES window but my preference is to link the PASSWORD, via an EXPRESSION and Package.Variable, back to the dtsConfig file.
I cannot use INTEGRATED SECURITY (as per client request -- they want to use 'sa' and it's password)
Any feedback is appreciated.
April 9, 2009 at 8:50 am
I don't think you want the sa password in a config file. That's got "we want to be hacked" written all over it.
That said, you should be able to build your connection strings dynamically in the package. I've done that plenty of times. If you do so, you can use variables in building the string. Note that you need to turn off pre-validation if you do this, or you'll have serious problems with the package, because it won't have a valid connection string until runtime.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply