0

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

Improve this question

1 Answer 1

Reset to default
1

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.