Call Stored Procedure in SSIS
Posted on 2011-10-05
I've a SSIS package which export data in flat files from database.
I need to export around 15 flat files from different tables based on query.
So, I created a stored procedure with input parametrized; based on that I can distinguish which query will be executed and based on that record set.
But, when I tried to call that SP in SSIS then it always return first query record set only in old db source when click on column. That is, if I pass a flag value which should return 3rd query result and columns then it still shows first one.
In ole db source, I am using, for e.g., EXEC SP_Name 'xyz'.
Do you have any clue on that?