I want to reuse an ssis package that was created by using the import wizard in a sql server 2008 r2 standard edition database. To accomplish this task, I have the following questions: 1. Is it better to save the SSIS package to the file system or the database and why? Can y0u give me directions how have to save and reexecute the package? 2. The input and output file names are the same except for having month/day/year as part of the file name. Thus can you tell me how to modify the SSIS package so the package will take file names that are dependent upon the date? Do I supply the SSIS package with parameters?

Hi Wendy, You may consider creating a scheduled job using SQL Server Agent to execute the package periodically. More info can be found here http://msdn.microsoft.com/en-us/library/ms141701.aspx Also, for varying filename(date and time part), suggest you use SSIS variables. This excellent article by Jamie will guide you http://consultingblogs.emc.com/jamiethomson/archive/2005/03/19/SSIS_3A00_-Evaluating-variables-as-expressions.aspx Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog

Hi Wendy, You may consider creating a scheduled job using SQL Server Agent to execute the package periodically. More info can be found here http://msdn.microsoft.com/en-us/library/ms141701.aspx Also, for varying filename(date and time part), suggest you use SSIS variables. This excellent article by Jamie will guide you http://consultingblogs.emc.com/jamiethomson/archive/2005/03/19/SSIS_3A00_-Evaluating-variables-as-expressions.aspx Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog