Link to home
Start Free TrialLog in
Avatar of sqlcurious
sqlcuriousFlag for United States of America

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
Avatar of lcohan
lcohan
Flag of Canada image

You could open SSMS, connect to your SQL server, expand databases, Right click the one you need and select "Export Data" from Tasks.
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.
Avatar of sqlcurious

ASKER

Is there any way i ca use visual studio BIDS
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.