May 30, 2011 at 10:06 am
I have a variable "country" and I insert a script task in a control flow with this readonly variable.In the script task I wrote only this simple VB code:
Dim country As String
country= Dts.Variables("country").Value.ToString
MsgBox(country)
If I try to use different package configurations,I saw that returns only the variable of the last package (of course when I use dtexecui...)
Example: I have a dtsconfig (xml file) with value of country=Italy and another one with country=Poland.
When I run dtexecui /FILE "c:\my.dtsx" /CONFIGFILE "C:\Italy.dtsConfig" /CHECKPOINTING OFF /REPORTING EW
msgbox returns Poland (because it's the last dtsconfig in the SSIS ->Package configuration).If I move Poland Configuration above, I am able to see Italy (but I always see Italy in the msgbox, even I use Poland.dtsconfig).
Do you know that it's some bug with dtsconfig in Visual Studio 2008? In Visual studio 2005 I don't have any problem.
Thank you
Anto
Anto
May 30, 2011 at 10:27 am
I don't quite understand what you're describing - but there are differences in how 2008 applies package configurations versus how 2005 did it. You should read Dougbert's blog post on How SSIS package configurations are applied.
Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply