Variable not showing value in Script task in ssis

Question

i am new to ssis and i am facing an issue in script task. In my package.dtsx, i have a script task and i am assigning a variable to get the ssis variable

string strSourceFile = Dts.Variables["VaFilePath"].Value.ToString().Trim();

strSourceFile shows the file path "D:\Test" correctly. below the script task i am using data flow task to do one process and it works fine. After data flow task i am using another script task and i am assigning a variable to get the ssis variable

   string strSourceFile = Dts.Variables["VaFilePath"].Value.ToString().Trim();

but strSourceFile is empty. i am not able to figure out the reason Please help

same ssis variable VaFilePath only i am using twice the scope is Package only, one time it works other time it doesnt, — user3734234
– user3734234, Commented Jul 31, 2014 at 10:44
maybe add some more info. Like more code. How your SSIS package looks like. — Darka
– Darka, Commented Jul 31, 2014 at 11:09
What is modifying your SSIS variable VaFilePath between the first Script Task and the last Script Task? — billinkc
– billinkc, Commented Jul 31, 2014 at 14:22

Tak · Accepted Answer · 2014-07-31 19:46:54Z

1

Since I cannot add a comment..

Have you check the Variable expression property that there is no expression that is changing the value.

Are you passing the variable to Script as readonly parameter? This may eliminate changing the value by mistake in the script.

answered Jul 31, 2014 at 19:46

Tak

1,5921 gold badge9 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Manoj De Mel Over a year ago

I had a similar issue. Variables not showing up in "Variables." collection. I had to add (select the) variables as Readonly (in my case) in order for them to be populated in the script.

Zach Smith · Accepted Answer · 2018-05-21 18:17:25Z

0

If your package is initiated by a controller package (for example via the "Execute Package Task"), and the controlling package binds variables to the child package, then you need to execute your child package from the context of the controlling package. i.e. if you are debugging and you execute the child task, there will be no values for package binded variables.

I'm mentioning this because I saw the same thing, and this was the reason.

edited May 21, 2018 at 18:17

answered May 21, 2018 at 17:34

Zach Smith

9,05615 gold badges74 silver badges152 bronze badges

Collectives™ on Stack Overflow

Variable not showing value in Script task in ssis

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related