How to pass parameterised value by user variable in SSIS? RRS feed

  • Question

  • Hi All,

    i have one excel in which three coloumn there A,B,C . Again in A coloumn the value of A that is valueA is present in that excel.now i have one DB2 database. All i want is i run the query like select valueB,valueC from table where A=valueA. in database db2 again in retrived result i want to put that valueb,valuec infront of respective valueA in that excel sheet. How can i do this with the help of SSIS?? Please Help. Any question let me know.

    Tuesday, February 8, 2011 1:05 PM

All replies

  • Also for this i have  took one excel source then OLE DB Command and then Excel destination, So in that OLE DB Command i have written the query now my question is how can i pass the parameter to that query using USER VARIABLE. The query is like giving above referance, select valueA,valueB from table where A=?. So how can i pass this value to '?' in this query.? Help me please.
    Wednesday, February 9, 2011 1:52 PM