Technet Link to Identify SSIS Errors:
Refer to this MSDN Documentation site for obtaining detailed information about the Errors often encountered in SSIS Packages.
http://technet.microsoft.com/en-us/library/ms345164(v=sql.100).aspx
02 Jun 2012 Leave a comment
SSIS gameplan..
11 May 2012 Leave a comment
In this Introduction to SSIS, I will walk you through the basic ETL tasks. ETL as Extract Transform and Load process helps as a good backend process to absorb and refine the data obtained from multiple source systems. SSIS packages use multitude of “Transformation” tasks, each suiting a particular purpose in mind.
When we open BIDS and open a new SSIS project, a default package with name “Package.dtsx” is created by the application.
All packages have extension of “.dtsx”. If while renaming a package, we forget to add this extension, the package is moved to “Miscellaneous” folder.
This leaning Tutorial spans into 9 parts,
Part 1: Control Flows and Connection Managers
Part 2: Data Flow Tasks
Part 3: Event Handlers
Part 4: Package Explorer
Part 5: SSIS Variables
Part 6: Package Deployment and Security
Part 7: Advanced Learning
Part 8: Useful resources
Part 9: Q & A
Enough of the talk. Let’s learn SSIS through web videos provided in the site!