CODEWITHSUNDEEP
ssis
SaNa3819
SaNa3819

Reputation: 347

Create every time newly excel file and transfer database value

How can I create a new Excel file and transfer all the data from the database using SSIS?

Upvotes: 0

Views: 47

Answers (1)

SinisterPenguin
SinisterPenguin

Reputation: 1618

Have you tried "Export Data" from SQL Server Management Studio.

Right click the database, choose Tasks -> Export Data & follow the wizard, works really well for simple exports in my experience.

You can save the SSIS it creates if you need to make any mods.

Upvotes: 1

Related Questions