Search:
Search questions and share your knowledge with the world here on Questionpoint.

Interview Question in SQL Server Integration Services

In SSIS , i created sql procedure the will return huge amount of records and using SSIS Control i have stored as flat file, how to do?

Answers to "In SSIS i created sql procedure the will return huge amount of records and using SSIS Control i have stored "

RE: In SSIS i created sql procedure the will return huge amount of records and using SSIS Control i have stored ?
Not entirely sure I understand your question. You have stored it that way or you want to? If you want to store the results of your procedure as a flat file, one way would be to store your results in a new table, then back up that table as a csr file or some other format.
Vote for this answer ::

RE: In SSIS i created sql procedure the will return huge amount of records and using SSIS Control i have stored
You need to create a data-flow task.. Souce as OLEDB or whatever you have and destination will be your flat file..
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Search questions and share your knowledge with the world here on Questionpoint.