Post reply

How to use a variable in sql query

  • May 16, 2011 at 10:50 am

    #250328

    I have populated a value in a variable but how can I use that variable in a query in Ole db destination? Here there are no parameters to set button.

    Thanks.

  • May 16, 2011 at 11:14 am

    #1325313

    Hi Ramadesai108,

    If you want to store the value of your variable inside a table via an OLE DB Destination, one method is to use a Derived Column Transformation to add a column, containing the variable value, to the rows in your Data Flow Task.

    Hope this helps,

    Andy

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

  • May 16, 2011 at 11:44 am

    #1325339

    Hello Andy,

    Thanks for your response. There must be a way to use the variable inside a query instead of storing it in a table.

    Thanks.

  • May 16, 2011 at 11:49 am

    #1325345

    What is the problem you are trying to solve?

    Andy

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

  • May 16, 2011 at 12:29 pm

    #1325375

    I am trying to fetch a subset of data from one database, insert that data into staging table. Then take the new records from staging and insert into the destination table as fastload. Then take the records that are updates from staging and update the destination table. But for updates I wanted to use destination ole rather than sql task. One of the issue I am facing is the date datatype. When creating the variable I use DateTime, but when setting the parameter for SQL task, there is no Datetime so I use Date. But looks are they are not compatible.

    Thanks.

  • May 16, 2011 at 2:34 pm

    #1325472

    Try the DT_DBTimeStamp data type.

    Hope this helps,

    Andy

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

  • May 16, 2011 at 2:41 pm

    #1325475

    DT_DBTimeStamp is not avialable for Parameter Mapping.

    THanks.

  • May 16, 2011 at 2:47 pm

    #1325480

    Please email the package to me: andy.leonard@gmail.com. I'm missing something.

    :{>

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

Viewing 8 posts - 1 through 7 (of 7 total)

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