Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kenchee
Starting Member
49 Posts |
 Posted - 2010-02-24 : 20:52:12
|
| Hi All, I've created a SSIS that has a configuration file. I've deploy this as a job in the SQL Server Agent (SQL 2005 SP3 CU7). I've changed the log file location (from C:\ to E:\), sql server username and password. When I ran the job, it failed saying that the username from the connection manager does not have access. This username is not the same as the one I configured in the configuration file. However, after modifiying the username in BIDS and redeploy it, it worked but it still reads the log file location and password from the configuration file. My question is why is the SSIS reading some values from the configuration file and some directly from the package it self?extract of the dtsconfig file for username<Configuration ConfiguredType="Property" Path="\Package.Connections[SQL_CONN].Properties[UserName]" ValueType="String">RegardsKen |
|
|
kenchee
Starting Member
49 Posts |
Posted - 2010-02-24 : 22:09:36
|
| Hi All, Found the issue. Because this is an xml file, one of my values have an & in them and that is what causing it not to take the username from the config file. I had to use & to get it to work.Ken |
 |
|
|
|
|
|
dtsconfig weirdness in SQL Agent