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
 Other SQL Server 2008 Topics
 Update Dates in an SSIS Package in Visual Studio

Author  Topic 

mlawton
Starting Member

35 Posts

Posted - 2015-04-14 : 15:52:50
Is there a way to update the same date multiple times in an SSIS Package?

I have an SSIS package in Visual Studio 2008 that has about 20 Execute SQL Task and about 15 Data Flow Task. Is there a way to update the date of 2014-04-10 in each of the 20 Execute SQL Task and in each of the 15 Data Flow Task? I would like to change the date to 2014-04-12 without having to maually change the date in each of the 20 Execute SQL Task and in each of the 15 Data Flow Task.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-04-14 : 16:03:38
Create a variable that uses an expression and then use that variable in each of the tasks.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

mlawton
Starting Member

35 Posts

Posted - 2015-04-14 : 16:15:02
Thanks. That sounds simple. But, how do I create a variable?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-04-14 : 16:18:05
I'll let you google that. It's a widely covered topic.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

mlawton
Starting Member

35 Posts

Posted - 2015-04-14 : 16:25:34
Thanks Tara!! I already started the process.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-04-14 : 17:15:36


Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -