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.
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
mlawton
Starting Member
35 Posts |
Posted - 2015-04-14 : 16:15:02
|
| Thanks. That sounds simple. But, how do I create a variable? |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
mlawton
Starting Member
35 Posts |
Posted - 2015-04-14 : 16:25:34
|
| Thanks Tara!! I already started the process. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Update Dates in an SSIS Package in Visual Studio
Tara Kizer