Pages

April 23, 2008

SSIS Help

Whether you are having issues creating your first package or you are an experienced SSIS user but have been dealing with the hardest issue ever, know that you are no alone. The SSIS community has grown so much the last few years as the number of resources out there. Let me introduce a short list of places where you can go to get good information and answer to most questions you may have:

Books on line SSIS 2005. A great place to start, you can either follow the tutorials if you are a newbie, or use it as a reference.
Books on line SSIS 2008 A great place to start, you can either follow the tutorials if you are a newbie, or use it as a reference.
MSDN Forums: A Microsoft hosted forum and the most active one I am aware of, where several MVPs, Micorsot folks and other comunity members gather to ask and answer questions.
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/threads/

SSIS Live Search Macro. A Live Search macro created by Jamie Thomson that covers many SSIS relevant sites and blogs.

Update 11/19/2008: Douglas Laudenschlager blog. Doug is part of the SSIS documentation team and frequent blogger

9 comments:

  1. Please note that there is also a separate new MSDN forum for SQL Server 2008 Integration Services.

    SQL Server Katmai Integration Services

    ReplyDelete
  2. Saludos Camarada, felicitaciones por el premio; espero verlo los días que se acerque a Vzla, de alguna manera cuadramos eso!.

    Un abrazo!

    ReplyDelete
  3. Douglas, I knew about that forum, and actually my intention was to provide a link to the main page of the SQL forum as, at some point, both 2005 and 2008 will be merged. Thanks for pointing that out, I have updated the link accordingly.

    ReplyDelete
  4. while i m exporting excel file using excel destination then it always leave one blank row. how can i remove this blank row.

    ReplyDelete
  5. I have a csv file having two same column names. How to import this file in a table. As it gives error while taking the same column names

    ReplyDelete
  6. Hi I have a table with 16 columns and 25 records, except for the Id column all other columns have repeating values, its a parent child relation table, i need to pivot the table and make the hierarchy from node to leaf.

    ReplyDelete
  7. Hi , I have to run a ETL between certain date range ie (Start date and end date)i have create a script to move the end date variable to start date variable and system date to end date variable ... How do i go about doing it , i can not use control table .. any other suggestions

    ReplyDelete
  8. I HAVE A SSIS PACKAGE WHICH RUNS LOCALLY ON MY SYSTEM, HOW DO I SET UP THE CONNECTION STRING USING THE EXPRESSION, SO THAT I CAN USE ON OTHER SYSTEMS. PLEASE REPLY

    ReplyDelete
  9. James, I see 2 options. A) Modify the package and use package configurations or B) use the /SET option of DTEXEC to override the connection string values.

    Have you tried using the links provided in this post to research or ask questions?

    ReplyDelete

I will love to hear your feedback and comments. Thanks.