question

mlawton avatar image
mlawton asked

Is there a way to update multiple dates at one time 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 the 20 Execute SQL Task and in the 15 Data Flow Task? I would like to change the date to 2014-04-12 without having to maually change each of the 20 Execute SQL Task and the 15 Data Flow Task.
visual-studio-2008execute-sql-task
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
mlawton avatar image
mlawton answered
I found out that you need to create a variable that uses an expression.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.