Post reply

auto remap at run time

  • August 21, 2008 at 1:03 am

    #72719

    I need to run a dts which picks up one/more file(s) from a folder then update the table(s) in the database based on the name of the file. The files are not consistent, so, sometimes it can be table1, sometimes it can be table2 & table4 & table5.

    I use the text file (source) & MS OLE DB SQL Server linking with a transform data. I'm able to change the text file (source)'s filename using the global variables. However, it always stops at the transform data because it does not auto remap the columns.

    How can I get around this?

  • August 21, 2008 at 9:33 am

    #861371

    Hi,

    I would suggest setting up the five different transforms in the package. You can then use an ActiveX script before the transforms to enable one transformation(or disable the other four transformations).

    Have a look at http://www.sqldts.com/218-2.aspx for disabling package steps.

    HTH


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • August 22, 2008 at 12:54 am

    #861674

    Thanks. That looks like what I need. I'll give it a try.

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

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