Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stan Kulp Batch ETL of Multiple Data Files Using an SSIS Foreach Loop Container RE: Batch ETL of Multiple Data Files Using an SSIS Foreach Loop Container

  • January 26, 2015 at 3:42 pm

    #1773255

    To be able to use FileInfo, you have to import library reference Microsoft.SqlServer.SmoExtended if you are using SQL2008 or SQL2008R2 and then use it in your Script Main window by Using Microsoft.SqlServer.Management.Smo;. You might want to bring Microsoft.SqlServer.Management.Collector and Microsoft.SqlServer.Management.Common as well.