ADO.Net Source need to use variable query

Leo Torres
Leo Torres used Ask the Experts™
on
I have an ADO.Net Connection that goes to a Teradata source. The query gets created on the fly by expressions and SQL TASK before I pass it to the ADO.Net Source but I cant figure out a way to pass my query to the ADO.Net Source.

The only 2 options I get are "Table and View" and SQLCommand
I tried SQLCOMMAND and placed the variable holding query in the input box but it failed.

OLE Source has the variable option to use a variable  for query. I cant user OLE because I dont have the drivers installed for Teradata. How can i get my query on to this ADO.Net source?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Co-Founder and Chief Architect
Top Expert 2016
Commented:
The number of Experts who have access to Teradata is probably limited, but if you can provide more details like screenshots or what you're trying to do and the expected result you may be able to get more answers.

Author

Commented:
http://blog.reckonedforce.com/tag/ssis-use-parameter-with-ado-net-source-in-data-flow/

OK, so I answered my own question here looks like to do an expression on the source query you have to set the expression back on the control flow level not the Data flow level which is what makes sense and that's the way it is for OLE.

Now my issue has become the sort. chose the sore column but it still says its not sorted
12

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial