SSIS Create extract file with Date and Time for a filename

In last weeks posting, we created our first SSIS package which queried a database and saved the information to a file so we could send the information to a user.  This week we are going to modify that same package to save the file with the date and time included in the filename.

Continue reading SSIS Create extract file with Date and Time for a filename

Creating Your First SSIS Project

What is SSIS?  It stands for SQL Server Integration Services which may be used for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing.  Today I am going to show you a simple solution on how to extract data and save it to a file.  This exercise will show some commonly used elements to creating a lot of different solutions.

Continue reading Creating Your First SSIS Project