SSIS

SSIS – SQL task and Script Component

This below link explains in detail about creating a SSIS package in VS 2008, project folder structure and designer.  Good for a beginner. http://www.techbubbles.com/sql-server/creating-a-ssis-package-in-vs-2008/ Tasks in the Control flow toolbox: The Execute SQL Task: This task is widely used in the packages. http://www.sqlis.com/post/The-Execute-SQL-Task.aspx http://blogs.msdn.com/b/mattm/archive/2006/11/08/stored-procedures-with-output-parameters.aspx A word of caution is below: “MSDN recognize as a SSIS […]

Read More