December 12, 2011 at 5:02 pm
When I design SSIS package, I point it to a package configuration file using environment variable to point to an xml file on my file system.
My question is when I am in business intelligence BIDs, and click run, will that use the package configuration file ?
THanks
December 12, 2011 at 5:44 pm
sqlfriends (12/12/2011)
When I design SSIS package, I point it to a package configuration file using environment variable to point to an xml file on my file system.My question is when I am in business intelligence BIDs, and click run, will that use the package configuration file ?
THanks
Yes, as long as you've set it up to look to the environment variable, it'll pick up the variable in whatever environment it's in. I typically use a SQL Table pointed at via a connection string in my local and server environment variables, but same thing basically. You should be fine.
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
December 13, 2011 at 2:59 am
Clicking on 'Start Debugging' or right-clicking on a package and selecting "Execute Package" will result in the configuration file being used.
However, if you select a task/container and choose Execute Task/Container, I don't think configurations are used.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 13, 2011 at 10:55 am
Koen Verbeeck (12/13/2011)
Clicking on 'Start Debugging' or right-clicking on a package and selecting "Execute Package" will result in the configuration file being used.However, if you select a task/container and choose Execute Task/Container, I don't think configurations are used.
They will, but they'll use the settings the configuration had when the file was opened. If you mess with your configurations, save/close/re-open the package in your solution. You don't have to close the solution, you just need to get the package to reload.
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
December 13, 2011 at 2:06 pm
Evil Kraig F (12/13/2011)
Koen Verbeeck (12/13/2011)
Clicking on 'Start Debugging' or right-clicking on a package and selecting "Execute Package" will result in the configuration file being used.However, if you select a task/container and choose Execute Task/Container, I don't think configurations are used.
They will, but they'll use the settings the configuration had when the file was opened. If you mess with your configurations, save/close/re-open the package in your solution. You don't have to close the solution, you just need to get the package to reload.
Ah, good to know.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply