Post reply

Dynamic OLEDB source

  • January 16, 2009 at 9:52 pm

    #126768

    Hi,

    I am trying to export all tables from a database to the text file. I am passing the table names to data flow through a variable in the for each loop component.In data flow i am using OLEDB source and used data access mode as "Table name or view name variable". I have initialized the variable with one table name.

    Now problem is that it exporting only initialized table but not the other table that is the changed value of the variable.

    Can anybody help, how can i pass table name dinamically to the OLEDB source.

    Thanks

    Shailesh

  • January 18, 2009 at 10:05 am

    #928902

    shailesh (1/16/2009)

    Hi,

    I am trying to export all tables from a database to the text file. I am passing the table names to data flow through a variable in the for each loop component.In data flow i am using OLEDB source and used data access mode as "Table name or view name variable". I have initialized the variable with one table name.

    Now problem is that it exporting only initialized table but not the other table that is the changed value of the variable.

    Can anybody help, how can i pass table name dinamically to the OLEDB source.

    Thanks

    Shailesh

    You cannot do it this way. The SSIS data flow is static in nature and tied to particular structure. I'm guessing your tables have very different structure from one another. I would recommend that you implement your tables export in script, avoiding the use of the data flow task.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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