Post reply

How to Call variable value in OLEDB Command SSIS

  • February 4, 2015 at 4:14 am

    #294496

    Hi ,

    I am facing one issue in **SSIS OLEDB Command**.

    under OLEDB Command there is sql update query

    UPDATE dbo.ArchiveBBxFbapp

    SET LatestVersion = 0

    WHERE BBxKey = ?

    dbo.ArchiveBBxFbapp is the name of the table, which I want to change by dynamically on fly.

    table name I am getting from variable .

    I want to take same variable value instead of hard coded table name in update statement.

    suggest me the correct command

    thanks and regards,

    Vipin jha

  • February 4, 2015 at 4:53 am

    #1775246

    Not possible, as far as I know.

    You can parameterize it, if you have 2012+, by right clicking on its data flow task and selecting 'Parameterize' (who'd have thought?) – though parameters are, of course, read only at run time.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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