Help on Script Task

SSIS and Import/Export
1

Hello All,

I have a requirement to generate file based on table data.But table's and layout can change during each run.I am thinking to configure all possible layout's with table name in DB and generate the data dynamically during each run.Once we have the data,is it a good advise to proceed with script task to generate the file as we cannot predict the colums.Please help on the steps I have to tak.Also is there any disadvantages using script task.

I am new in SSIS.

Thanks In Advance!

2

You should read this article:

8 Ways to Export SQL Results To a Text File – SQLServerCentral

You can use the script to generate the file, using c# it shouldn't be needed to configure all possible layout's. If you us Dynamic SQL in a stored procedure I think it should be sufficient to execute the stored procedure but it would depend on your requirements.