Home Forums SQL Server 2005 SQL Server 2005 Integration Services Sql command not taking the packagevariable value RE: Sql command not taking the packagevariable value

  • July 6, 2009 at 6:52 am

    #1020323

    Phil Parkin (7/6/2009)

    OK, not quite correct for an OLEDB source.

    First you need to assign the whole SQL string to a variable, then you need to change the Data Access Mode on your OLEDB source to be SQL Command from variable - the rest is obvious, I think.

    Phil

    Hi Phil,

    I have assigned this query text into one variable and i have used sql command from variable but still it is not taking that variable value. however when i am displaying the effectivedate variable value in message box it is showing properly. task is executed successfully but i am not getting the result what i have expected. Can you find out what may the other cause for that?

    Thanks

    Senthil