Post reply

Need help with SSI

  • November 19, 2007 at 4:41 pm

    #122453

    Hi,

    I am new to SSIS, but have wast experience with DTS. I am well versed with .net programming as well. However, I find it hard to access the SQL Server DTS object model and putting it to use. Have you experienced similar issue when starting with SSIS? If yes, what is the path I should follow to get a handle on this quickly? Any books or great websites providing tutorials?

    Thanks in advance,

    Palak Mody

  • November 19, 2007 at 8:03 pm

    #752498

    My first thought is - Why do you need to access the object model when you have a perfectly acceptable (IMHO) IDE ?

    If you found programming the DTS object model difficult, then I think that you will struggle with the SSIS object model. SSIS has a much larger and more complex object model when compared to DTS.

    If you need to directly program the object model, I would start by looking for code samples (using google). There are quite a lot of them out there.

    There are also applications that will read a SSIS package and output the equivalent as C# code (using the SSIS object model). This might be useful since you will have examples of the code that you can use.

  • November 20, 2007 at 12:30 am

    #752534

    Thanks for the response. My bad - I was successful at programming with DTS, but I am having hard time programming SSIS. Perticularly I find error logging to be challanging.

    I found multiple samples using web search, but I also found it difficult to deploy their logic since either it was not relevant to what I was looking for or it was not illustrated properly.

    It would be a great help if someone can point me out to some tutorial or a great book based on their own experience.

    Thanks again,

    Palak Mody

  • November 20, 2007 at 8:01 am

    #752714

    Brian Knight has a couple of good books on SSIS. There is also Jumpstart TV (http://www.jumpstarttv.com/) that has some good free resources. SqlIS.com is another good site for SSIS information.

    Tim Mitchell
    TimMitchell.net | @tmitch.net | Tyleris.com
    ETL Best Practices

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply