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 package is being run on the same server that you are inserting into. Why is my Excel interop failing intermittently in my Script Task? How do I set a flat file name for flat file connection manager dynamically? How do I use dynamic T-SQL in Lookup? How do I use lookup transformation to load data incrementally? How do I perform data type conversions in SSIS? How do I create a folder for SSIS package in MSDB with T-SQL? How do I resolve the error "Connection is busy with results for another command"? How do I programmatically create a Transfer SQL Server Objects task? How do I execute a stored procedure with a return value and an output parameter in an Execute SQL Task? How do I use the Fuzzy Grouping transformation? How do I use Integration Services to achieve Push-mode processing for Analysis Services? How do read data from Excel 2007 with Integration Services 2005? How do I upgrade my DTS packages to SSIS 2008 packages? How do I troubleshoot SSIS packages failed execution in a SQL Agent job? How do I track the error message when my SSIS package failed execution? How do I troubleshoot a connection error regarding DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER ? How do I troubleshoot SSIS package hanged for running? How do I use SSIS to completely transfer my database including logins, users, and permissions from one server to another server? How do I record log information in Script Component? How do I create and deploy a SSIS custom task? How do I improve package loading performance in BIDS when I open a package which is imported from another place? 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

good meat! thanks

Hi, This is a very very good information..thx a lot... maruthi..

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

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

the system.io namespace is one of the most commonnon-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

Microsoft SSIS Forum Support SSIS Knowledgebase Articles

Awesome info! Thanks John K. Knowledgy Solutions http://knowledgy.org/

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

Great Info..

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

Very good info ..covers all the details..

Check out my Microsoft BI Introduction Videos blogpost at http://kferrier.blogspot.com/2009/10/microsoft-bi-introduction-videos.html. It has a video of Mike Hotek's presentation Introduction to SQL Server Integration Services 2008 given to the Oklahoma City SQL Server Developers Group this summer.

Thanks a lot, Very good information.

Great resources but seems need updating.

Great resources but seems need updating. Such as?Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer

Few more links (didn't yet checked if already mentioned) could be found in http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/e00f1cbb-794e-49fa-9977-f46f4ece798f thread.Premature optimization is the root of all evil in programming. (c) by Donald Knuth Naomi Nosonovsky, Sr. Programmer-Analyst My blog

Another great tool for BI Developers released on codeplex.BI xPress : (Package Builder, Auditing, Notification, Monitoring, Deployment and more ... )http://bixpress.codeplex.com

Great resources overall but I was wondering if someone could put in a newer update. The user constitutions have been really helpful especially the BI developers tool on codeplex. ---- Our Flagstone Toronto Website

Hi Phil, Todd or other moderators who have permission to edit this sticky post, My colleagues and I have published about 20 FAQs in this forum in these days. Since you already have create this sticky post for resource collection, I do not want to create a new sticky post for indexing these FAQs. Could you please help add the following 20 threads into the FAQ list? Thank you very much! How do I set a flat file name for flat file connection manager dynamically? How do I use dynamic T-SQL in Lookup? How do I use lookup transformation to load data incrementally? How do I perform data type conversions in SSIS? How do I create a folder for SSIS package in MSDB with T-SQL? How do I resolve the error "Connection is busy with results for another command"? How do I programmatically create a Transfer SQL Server Objects task? How do I execute a stored procedure with a return value and an output parameter in an Execute SQL Task? How do I use the Fuzzy Grouping transformation? How do I use Integration Services to achieve Push-mode processing for Analysis Services? How do read data from Excel 2007 with Integration Services 2005? How do I upgrade my DTS packages to SSIS 2008 packages? How do I troubleshoot SSIS packages failed execution in a SQL Agent job? How do I track the error message when my SSIS package failed execution? How do I troubleshoot a connection error regarding DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER ? How do I troubleshoot SSIS package hanged for running? How do I use SSIS to completely transfer my database including logins, users, and permissions from one server to another server? How do I record log information in Script Component? How do I create and deploy a SSIS custom task? How do I improve package loading performance in BIDS when I open a package which is imported from another place? Please remember to mark the replies as answers if they help and unmark them if they provide no help

Collection of Tutorials and videos on MS SQL server. Tutorials: http://www.dataminingtools.net/browsetutorials.php?tag=mss Videos: http://www.dataminingtools.net/videos.php?id=3

These are great resources on BI developers tool. Does anyone have any new updates? ---- Carpet Cleaning Toronto

For additional Learning resources, see the following Integration Services instructional videos. These videos apply to 2008 and 2008 R2 SSIS. Designing Your SSIS Packages for Parallelism (SQL Server Video) Measuring and Understanding the Performance of Your SSIS Packages in the Enterprise (SQL Server Video) Understanding SSIS Data Flow Buffers (SQL Server Video) Tuning Your SSIS Package Data Flow in the Enterprise (SQL Server Video) Exporting SQL Server Data to Excel (SQL Server Video) How to: Automate SSIS Package Execution by Using the SQL Server Agent (SQL Server Video)? Troubleshooting: SSIS Package Execution Using SQL Server Agent (SQL Server Video) How to: Implement a Lookup Transformation in Full Cache Mode (SQL Server Video)? How to: Use the Data Profiling Task (SQL Server Video)? Creating a Basic Package (SQL Server Video) How to: Call a Web Service by Using the Web Service Task (SQL Server Video)?

Few more links (didn't yet checked if already mentioned) could be found in http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/e00f1cbb-794e-49fa-9977-f46f4ece798f thread. Premature optimization is the root of all evil in programming. (c) by Donald Knuth Naomi Nosonovsky, Sr. Programmer-Analyst My blog Is the problem with the my network here? The link cannot be opened.

hi! Do someone have source code of MSDN Architecture Webcast: Using SQL Server 2005 Integration Services to Populate a Kimball Method Data Warehouse (Level 200),Do tell plzmhassanshahbaz