FAQ - SSIS Information, Webcasts, Tools, Add-ons, etc...

Question

To add to the list, simply contact on the moderators around here, or post a reply to this thread.

Microsoft Reference Material
SQL Server Integration Services Portal on MSDN - videos, whitepapers, product overviews, blogs
SQL Server Books Online for Integration Services - complete reference material
    * Designing and Implementing Packages Tutorials
    * Performance Tuning Techniques
    * Microsoft SSIS Connectivity Whitepaper
Using the System.IO Namespace in your Script Task
Top Microsoft Knowledgebase SSIS articles

Frequently Asked Questions
An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step
How do I sort packages in Solution Explorer?
How do I check to see if a record exists in my destination and update it, and if it doesn't exist, insert it?
Why are my mapped drives not working?
    - Avoid them at all costs.  Use UNC instead. (\\server\share\...)  Mapped drives are only available to the currently logged-in user session and when you run SSIS package via a job (SQL Agent or otherwise) mapped drives are not available because there is no user session.
Why is my SQL Server Destination component not working?
    - It can only be used when the pckage is being run on the same server that you are inserting into.
Why is my Excel interop failing intermittently in my Script Task?

Best Practices Resources
Top 10 SQL Server Integrations Services Best Pratices by SQL CAT

Learning Resources
Webcasts
    * TechNet Webcast: SQL Server 2005 Integration Services: Performance and Scale (Level 400)
    * MSDN Architecture Webcast: Using SQL Server 2005 Integration Services to Populate a Kimball Method Data Warehouse (Level 200)
Integration Services oriented Websites
    * SQLIS.com
    * SQLBI.eu
    * JumpstartTV
    * LearnMicrosoftBI.com

Tools and Add-ons for Integration Services
SSIS Community Tasks and Components project on CodePlex
    * BIDSHelper
    * over 80 other Tools, Tasks, and Data Flow Sources, Transforms, and Destinations for SSIS 2005 and 2008

DTS Related Questions (SQL Server 2000 and older versions)
    * DTS newsgroup: http://www.microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.sqlserver.dts

Answer 1

good meat! thanks

Answer 2

Hi,

 

This is a very very good information..thx a lot...

 

maruthi..

 

Answer 3

Here's one that looks interesting: http://cozyroc.com/

Answer 4

Don't know if it is just me, but Jamie T's search macro appears to be throwing an error...

Answer 5

the system.io namespace is one of the most common non-native .net namespaces implemented in ssis script tasks. it would behoove any serious ssis developer to become familiar with the classes in this namespace: http://msdn.microsoft.com/en-us/library/system.io.aspx

 

hth

 

Answer 6

Microsoft SSIS Forum Support

 

SSIS Knowledgebase Articles

Answer 7

Awesome info!  Thanks

---

John K. Knowledgy Solutions http://knowledgy.org/

Answer 8

an excellent set of video tutorials is at http://www.learnmicrosoftbi.com/Home/tabid/37/Default.aspx

Answer 9

Great Info..

Answer 10

HI ALL,

This information is really helpful, and Thanks for all your contribution to this thread.

---

SatBI