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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Using Variables in Execute SQL Task

Author  Topic 

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2011-03-02 : 02:29:50
Hello everyone,

I am newbie in SSIS.
I have done some dataflow tasks which were executed successfully.
now i have to update one table with the following statement.

UPDATE trnCallDetails SET CustID =
But here I need to put the value from SSIS Variable.

How to do that ?
Please help me out...

Vaibhav T

If I cant go back, I want to go fast...

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2011-03-04 : 05:37:35
Take a look at this article: http://www.sqlis.com/sqlis/post/The-Execute-SQL-Task.aspx
The "Usage Examples" may help.
Go to Top of Page

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2011-03-04 : 05:56:20
Yes I have gone through that link.
But somehow it is not taking the value from parameter maaping with the use of "?"
But I managed it through Expression.

Thanks for the reply...

Vaibhav T

If I cant go back, I want to go fast...
Go to Top of Page
   

- Advertisement -