SSIS 2008 Training Video: How to Assign the Filename of a Bulk In sert Task at Runtime Using Expressions

How to Assign the Filename of a Bulk Insert Task at Runtime Using Expressions - view details
How do you mix SSIS expressions with variables so you can customize your packages at runtime? This will allow your packages to become even more dynamic and usable. In this video Scott will show you how to assign the filename of a bulk insert task at runtime using expressions.
 
Highlights from this video:Bulk insert taskEditing the bulk insert task
Format files
Changing the value of a variable
Changing a destination table in an expression
Using the bulk insert task the the foreach loop container
and much more Source: http://www.learnitfirst.com/Course/158/Video/2134/Assign-Filename-Of-A-Bulk-Insert-Task-At-Runtime.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 300 (Intermediate) Length: 12:00 (19.8MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: SSIS 2008, bulk insert task, expressions assign filename at runtime

This video comes from the SSIS 2008 online training course, SQL Server 2008 Integration Services. And be sure to check out even more SQL 2008 Integration Services training videos.