0
Answer

How to Call variable value in OLEDB Command SSIS

vipin jha

vipin jha

9y
491
1


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