sqlcurious
asked on
SSIS
Hi Experts
I am new to ssis
i have a database and have multiple tables.I want to publish the rows of all the tables in different excel sheet at once using SSIS .Please provide me the steps
I am new to ssis
i have a database and have multiple tables.I want to publish the rows of all the tables in different excel sheet at once using SSIS .Please provide me the steps
ASKER
Is there any way i ca use visual studio BIDS
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
However, that is going to be one ugly SSIS package. You can set up a package, using buids, that will cycle through the tables and export them to Excel using a For Each Loop Container. Doing that, you could provide a control table that would identify the tables you want to export or, if you want to export them all, you could base it on the User Table entries in the system tables.
This will pop up a SSIS export wizzard where you easily can select all your tables as source and Excel as target but caution if you have lots of data. Then you can save this as SSIS instead of just execute it by clink Finish.