Dynamic Text File Creation Via Single SSIS Package

Speaker(s)Ross McNeely

Duration: 60 minutes

Track: Track 2

Creating individual SSIS Packages for individual business-to-business data files is not only time consuming, but becomes a maintenance nightmare.  This presentation will show you how to create a single SSIS package that can generate varying length and formatted text files.  By utilizing stored procedures you will see how the time from specification to file delivery can be greatly reduced and simplified.  Additional areas we will cover include the support tables to control file run times, creating file variables at run time, and how to report file success.

Back to Top