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)
 SSIS Global Variables

Author  Topic 

steve.hebert_1970
Starting Member

3 Posts

Posted - 2008-10-03 : 08:51:37
Hello All
Does any one know besides storing data in a perminent table on the db, is there a way to code into An SSIS package the ability to save somewhere values like "Run date"

I was able to use global variable and VB in activeX before....

Lets say the package runs today 10/3/2008 is there code to automatical save this date to config file or somewhere.....then tomorrow when it runs again i would want code to pick up the date of 10/3/2008 and store into variable "last run date" and resave 10/4/2008 to the config file...

thanks in advance for any advice.

Steve

steve.hebert_1970
Starting Member

3 Posts

Posted - 2008-10-03 : 14:07:18
Hello again
well i found a good article on how set variable at run time with VB code....

http://www.sqlis.com/306-2.aspx

does anyone know if I can set variable for a package from sql code.

Steve
Go to Top of Page
   

- Advertisement -