March 23, 2011 at 10:26 am
I am using a variable Y to store result set from an query (select convert(varchar(3),value) from system where b = x)
Everything seams to be fine (all green), but i can't see my variable updated with the value from the result set....Can anyone help me plz
And for information, i am setting variable Y as string data type
March 23, 2011 at 10:36 am
i can't see my variable updated with the value from the result set
What method are you using to check the value of the variable after the update?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 23, 2011 at 10:51 am
I am new to ssis, i have no idea about method...all i just care is to get the value assigned to Variable Y through the Query
March 23, 2011 at 10:55 am
quillis131 (3/23/2011)
I am new to ssis, i have no idea about method...all i just care is to get the value assigned to Variable Y through the Query
It's not easy to answer your questions if you are not prepared to answer mine.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 23, 2011 at 11:15 am
I am sorry ..if i was not clear. I meant to say, have no idea about method....
March 23, 2011 at 11:23 am
All i am using is Execute task and variable ....My requriment is to get the variable update as soon as the execute task gets green...Plz correct me if this not the procedure to update the variable..
the table on which i am querying is like this
ID Value Tag
=====================
1 1680 MXCO
.
.
.
356 720 RXMC
===========================
Now i should get the Value column on particular Tag say
select (varchar(3),Value) as value from table name where tag= 'MXCO'
So my variable should get updated with 168 value
I am using SQL task, Direct Input to give the query and the in result set mapping value to Value(variable user)...
If you are not clear plz let me know.....
March 23, 2011 at 11:28 am
OK.
If you are checking the value of the variable by looking at the Variables pane after execution of the package, you are looking in the wrong place. When a variable's value is set during execution of a package, the value is temporary and remains only while the package is executing.
To check a variable's value during package execution, I suggest that you set a pre-execute breakpoint on the task immediately following the Execute SQL task. When the package is run, execution will pause at this point and you will be able to inspect the current state of all package variables.
The reason for my initial question was that I was trying to determine whether you had already done this.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply