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?