It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

SSIS by example

SSIS development can be a frustrating experience. However it is becoming an increasingly important part of the SQL Server tool set and an important skill for the professional SQL server developer. The best way to learn SSIS is to see a real world example being built from scratch. The brief is to import a collection of delimited files into sql server, date stamp and archive the files, capture any errors and get the data into a SQL server table. It sounds straight forward but what if the file contains embedded quotes for example ("ABC","DEF",""Hello world, again""). Try importing this line using SSIS! You have to be able to adapt when using SSIS and this session will give you some ideas for getting round SSIS limitations and getting the job done.

About

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite.
There is a breadth of knowledge in the SQL Community that will benefit everyone in the community.
We want to spread that knowledge.

We all work with the SQL community, some of us for many years and have all been given the MVP award by Microsoft