How to Call variable value in OLEDB Command SSIS

Feb 4 2015 6:15 AM

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

SSIS multiple table loads using single DFT

Answers (0)