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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2007-08-08 : 04:37:38
|
| I have created a package configuration to read the connectionstring for the oledb connection manager.Saved the file as Environment.dtsConfig in the same directory as the other packages.Do the packages refer to the configuration file automatically?Does it make a difference if I use the dtexec to start the ssis packages since there is now a configuration file?Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-08-08 : 05:48:39
|
| >> Do the packages refer to the configuration file automatically?Only if the package is set to use the config entry. It will use any configs that are added to the filter.>> Does it make a difference if I use the dtexec to start the ssis packagesNope.seehttp://www.nigelrivett.net/DTS/SSISIndirectConfiguration.htmlhttp://www.nigelrivett.net/DTS/SSISConfigurationFile.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2007-08-08 : 06:21:06
|
| I moved one of the ssis packages from dev to prod.Did the same for the configuration file which contains the connectionstring.Now I would like to run the package in live but the error is: Description: The configuration file name "S:\Imports\Trades\Environment.dtsConfig" is not valid. Check the configuration file name.The file does indeed exist and the connectionstring has the correct string.Any thoughts please? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-08-08 : 06:34:17
|
| Is there an s drive and is that available to the account used to run the package? If it's a service account then the drive probably won't have been mapped to the letter if it's a network drive.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2007-08-08 : 08:23:14
|
| There was a problem with the path.Solved.Thanks |
|
|
|
|
|
|
configuration package