Making the SSIS Data Reader Source Query Dynamic
-
Hi Guys, My data source is FoxPro for Unix using ODBC connection i would like to bring it to sql 2005 by SSIS 2005. Can any one explain how i could use Dynamic SQL using SSIS Datareader Like for instance "SELECT * FROM " @[User::TableName] expression??? Please explain the Steps to follow. Thank you
-
Hi Guys, My data source is FoxPro for Unix using ODBC connection i would like to bring it to sql 2005 by SSIS 2005. Can any one explain how i could use Dynamic SQL using SSIS Datareader Like for instance "SELECT * FROM " @[User::TableName] expression??? Please explain the Steps to follow. Thank you
Member 8082021 wrote:
Can any one explain how i could use Dynamic SQL using SSIS Datareader Like for instance
Oh this is a fun one; you will need a variable and build the syntax of your query in an expression. Then in the 'data flow', 'source editor' change, 'data access mode' to 'SQL Command from variable. It can be done, just take a little bit of creativity.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
-
Member 8082021 wrote:
Can any one explain how i could use Dynamic SQL using SSIS Datareader Like for instance
Oh this is a fun one; you will need a variable and build the syntax of your query in an expression. Then in the 'data flow', 'source editor' change, 'data access mode' to 'SQL Command from variable. It can be done, just take a little bit of creativity.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
Thank you so much for your help. I am having an issue could you please give me a more detailed step in solving this problem. I have to sort this problem now. Please advice KB