Post reply

pass a parameter into a data flow to be used by a OLE DB source

  • August 9, 2007 at 12:02 pm

    #118114

    Hi, I am trying to figure out how to pass a parameter directly into a data flow to be used in an OLE DB Source.  I can't seem to find any place in the OLE source to specify a parameter will be used.

  • August 9, 2007 at 12:37 pm

    #725830

    What exactly are you trying change in OLE DB source?

     

  • August 9, 2007 at 12:43 pm

    #725832

    I am just trying to pass a parameter into the data flow to be used in a query to gather data.  For example.

    select name from master.dbo.sysdatabases where name = ?

    I can't find anyplace in the dataflow properities or the properties of the OLE DB Source object to define what variable I am using as the parameter.  I can pass parameters in Execute SQL tasks without any issue but can't seem to find the right place to define one in a data flow for some reason.

  • August 10, 2007 at 1:54 am

    #725911

    It's the same as a SQL task. You specify the query and place ? where you want parameters.

    You then map them to a variable by clicking on the Parameters button. Outside of the data flow, you change the value of the variable to what you want.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Viewing 4 posts - 1 through 3 (of 3 total)

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