I have some trouble executing a sql statement in SSIS package.
Here is what I'm trying to do.
I have a SQL statement (or stored proc) that I'm running to get a result set, and I want to put the result set into flat files.
In the sql statement, I have a dynamic query that will populate the data.
When I run it in SSMS, it runs without problem.
However, when I try in SSIS, I run into a problem.
I have used both temp table and table variable , but the result is same.
Please help me with this problem.