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 2005 Forums
 SSIS and Import/Export (2005)
 Variables

Author  Topic 

juancabrera
Starting Member

30 Posts

Posted - 2007-11-14 : 13:58:39
Hello,

I have a recordset that only has 1 record. I want to use this record to initialize the package variables. How do I do this? Or where do I do this?

juancabrera
Starting Member

30 Posts

Posted - 2007-11-14 : 14:28:50
Do I have to use a script task on the control flow and programatically set the value of the variable this way? If this is the way to do it, then it stinks that it will only let me write the script using VB.NET and not C#.NET.
Go to Top of Page

Hommer
Aged Yak Warrior

808 Posts

Posted - 2007-11-15 : 14:18:08
You could use an expression, which is neither t-sql nor VB.
Go to Top of Page
   

- Advertisement -