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)
 Dynamically create variables in script task??

Author  Topic 

bmassey
Starting Member

22 Posts

Posted - 2009-03-16 : 19:58:57
I'm trying to dynamically create and set variables within a script task. I'm calling a COM object for which returns a list of name/value pairs. The "name" should become the variable name and the "value" should be the value set to the variable. This is a process that I have done several times in DTS (Active X Script) but I am struggling trying to convert the logic to a SSIS script task.

Any assistance would be much appreciated!
   

- Advertisement -