Post reply

How to Proceed SSIS

  • March 24, 2009 at 10:45 am

    #202191

    I'm traditionally a C# programmer, but need to write an SSIS package to do select from an import table, and update a series of tables based on my first table. Typically I would write my application to do a select and put the returned records into a dataset where I would create a new update record via a foreach loop.

    So, what's the best way to do this in SSIS? I've been working with SSIS I'm about half way there, but didn't want to proceed doing something inefficient. Ideas and suggestions would be appreciated!

    Thanks.

  • March 24, 2009 at 11:03 am

    #965420

    For a large amount of updates i find the most effiecnt way is to put the updated value in a lookup table and then do the update using an Update statement with an inner join to the lookup table.

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

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