Home Forums Data Warehousing Integration Services How can I use parameterized query (Select statement Where Col1= 'U') in OLEDB source of Data Flow task? RE: How can I use parameterized query (Select statement Where Col1= 'U') in OLEDB source of Data Flow task?

  • June 27, 2016 at 2:28 pm

    #1887138

    You need to build the value of the variable as an expression as there's no place to define parameters in the data flow for the data source.

    "select name as [name], id as [id] from sysobjects where type ='"+ @[User::sSQLVariable] +"'"

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2