To add to the list, simply contact one of 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 * Technet SSIS Wiki (lots of connectivity info here) 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 * BIDN.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

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://pragmaticworks.com/products/Business-Intelligence/BIxPress/Overview.aspx SSIS-Tutorials-FAQs | Convert DTS to SSIS | Document Entire BI | SSIS Tasks | BIDS Plugin

Another great tool for BI Developers released on codeplex. BI xPress : (Package Builder, Auditing, Notification, Monitoring, Deployment and more ... ) http://pragmaticworks.com/products/Business-Intelligence/BIxPress/Overview.aspx SSIS-Tutorials-FAQs | Convert DTS to SSIS | Document SSIS | SSIS Tasks | Real-time SSIS Monitoring

video converter to avi 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99

Just popping in to say that SQL Server BI team now tweets @MicrosoftBI!Arthur My Blog

good meat! thanks Thanks Bala

By getting Microsoft-SQL-Server-2008 certification, you will be able to demonstrate a wider range of expertise in Microsoft field. Having this Microsoft SQL Server 2008 certification will also bring a new leading edge to your career path. CertDumps Microsoft SQL Server 2008 quality braindumps and latest practice exams will not only shorten your Microsoft SQL Server 2008 exam preparation process but also offer guaranteed success on first attempt. So what are you still waiting for? Join us today to ace your exam tomorrow.

Hi everyone. Does anybody know why my profile does not get updated since March 17th??Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com

Thanks a lot , Very important ;)Kind Regards , > Omar GHANNAM > Mobile +212 6 41 76 10 15 > Profil: http://ma.linkedin.com/in/omarghannam

I have a SSIS package and I am trying to modify a cnnection (OLEDB) by changing its server name. Each time I save the package and reopen the solution, it show me old server name in that connection. could you please help me to give some idea why it is behaving like this? Thanks Diptendu

Very useful information...Thanks Phil check this out SQL Hosting I hope it will help! Chaka http://www.sqlhosting.net/sql-server-hosting.php

Hi, I was having problems connecting to Oracle in a SSIS package that I scheduled in SQL Server 2008 R2 Agent. To fix the problem,I enabled "Use 32 bit runtime" in the execution option and it's been working since then. This was on my Test server. I have now moved the package to my production environment with the same spec as my Test but I'm getting the error below: 0.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 13:46:21 Error: 2011-05-19 13:46:25.19 Code: 0xC0202009 Source: IFS_Master Connection manager "IFS" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8007007E. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x8007007E Description: "The specified module could not be found.". End Error Error: 2011-05-19 13:46:25.20 Code: 0xC00291EC Source: Obtain IFS Last Update Flag Execute SQL Task Description: Failed to acquire connection "IFS". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 13:46:21 Finished: 13:46:25 Elapsed: 3.359 seconds. The package execution failed. The step failed. All the resources I've seen on the internet have not helped. I'd be grateful if you can help with this. Thanks, Cognitics

A new SSIS 2008 (and SSIS 2008 R2) transformation component released: Balanced Data Distributor A short usage scenario: This transform takes a single input and distributes the incoming rows to one or more outputs uniformly via multithreading. download from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ea0a1544-5ee4-4ad4-9d76-296d0632f162Arthur My Blog

Watch this video to see what is new in SSIS - Denali from Tech-Ed 2011 http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DBI317 Thanks Ayyappan Thangaraj UG Lead, Puducherry, http://SQLServerRider.blogspot.com

SQL Server Community FAQs Free eBook published Please note that this book is a collection of the most frequently asked questions and answers on the SQL Server related MSDN forums. It also includes a good number of SSIS questions. The complete post is here: http://blogs.msdn.com/b/sqlforum/archive/2011/06/10/sql-server-faqs-ebook-with-database-engine-ssrs-ssis-ssas-.aspx And to just download the entire book - http://2.ly/k37fArthur My Blog

Just for your information: Apparently the automatic alerts on replies do not work on MSDN forums. The fix is coming, in the meanwhile use Alert Me when replying. More info is there: http://social.msdn.microsoft.com/Forums/en-US/reportabug/thread/653f2e96-8679-431f-a32b-f5b93a762b42Arthur My Blog

Thanks, Arthur. I downloaded the PDF and it seems like a very good resource - I've checked the very first question right now.For every expert, there is an equal and opposite expert. - Becker's Law My blog

Yup this is nice :) Got some interesting stuff there... thx