Datareader source/Data flow task property expression problems

Hot Topic

2005 SQL EXPRESS DATABASE BACKUP
Cannot open database
Multiple transactions not working in package
Get the Report Model Fields of a particular report?
Delete remote files !!! PLEASE HELP !!!
performance of indexed views
SSIS Requests...
web services as data source?
trigger calls stored procedure- sometimes?
4 lookups against single large table

SQL Server

filtering rows that already exist in the destination table
positioning of report parameters when diaplayed in report manager
Setting a value of the query result to scalar variable
how do I determine how many columns there are in a file?
Log Shipping vs database mirroring
Send Mail Report with code
DB2 ODBC Connection Problems
Asp.Net not finding the SQLServer for setting up Security problem
Access web application is slow, should I upgrade to SQL server?
Problems with debugging remotely SQLCLR stored procedures?

Datareader source/Data flow task property expression problems

Hi all,
I have the June CTP version of Yukon and it's various tools, and I'm having an issue with using property expressions or variable syntax within the SqlCommand string of a datareader source within a data flow task. It seems as if there were issues in past versions of doing this within data flow tasks, but I thought with the June CTP that this was a possibility. The documentation even states that you can do this within the sqlcommand property. Anybody else have this problem Any solutions
Thanks,
Adrian Crawford

Answer this question

Datareader source/Data flow task property expression problems

  • Steve of Easyget.biz

    Hello Adrian,
    Not sure exactly what you mean by "I'm having an issue with using property expressions or variable syntax" Are you referring to it error-ing out, or are the values not showing up properly

    Maybe the workaround in this post might help you
    http://forums.microsoft.com/msdn/ShowPost.aspx PostID=70082

    Jason

  • Aengus O

    Hey Jason,
    Thanks for the reply.  It is erroring out and not accepting my sqlcommand when I try to use any dts variables in the query.  The datareader source works a little differently in that it doesn't give you the option to parse/build your query like other tasks do.  Unfortunately there is not much of an error message to give.  I get...
    Further changes need to be made before the current settings can be saved to the component. Warnings reported by the component are:

    And then nothing is listed.  I'm trying to query an Oracle db and use dts vars in the query, but i have a feeling they are not getting parsed before being sent to Oracle.

    Adrian

  • Saleem Hakani - MSFT

    Mark,
    Thanks for your response.  I figured out my problem in another recent post here:
    http://forums.microsoft.com/msdn/ShowPost.aspx PostID=73466

    Basically I found that you can't directly enter variables or expressions in the sqlcommand box, since it will not parse it before being sent.  I found the round about way in the above post.

    Thanks,
    Adrian

  • Parker Whittle

    Hi Adrian,
    Can you share your expression I'd like to try to reproduce this so I can see why the error message is incorrect.
    Also, what is the scope of the variables you are using

    Thanks
    Mark

  • Datareader source/Data flow task property expression problems
Answer this question