BY TOPIC▼
SQL SERVER BLOGS▼
SSIS BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Blogs from Wise Owl on Files and folders in SSIS
Showing blogs 1-3 (out of 3)
Using SSIS to loop over the worksheets in an Excel workbook, importing each
Posted by Andy Brown on 07 April 2016
Looping over Excel workbooks is one thing, but how can you loop over all of the worksheets in a single workbook, importing the contents of each? This blog explains the steps you need to follow.
Getting at file attributes from FOREACH loop in SSIS
Posted by Andy Brown on 30 January 2015
SSIS makes it easy to loop over files, but it's less obvious how to get at file attributes such as the date created or last modified date. To do this you'll need a scripting task, as explained by this blog.
SSIS: Executing SQL statement for each file
Posted by Andy Brown on 05 April 2013
How to store the name of each file in a folder in a SQL Server table using an Integration Services package.