question

apple avatar image
apple asked

Output to dynamic Excel file

Hi! I need to create an Excel file dynamically with today's date .It shows the results of a sql query. Final step will be to upload the excel file to share point. I googled and tried out few examples but I am confused with evaluating the connection managers and I am stuck at that part . Really appreciate any suggestions Thanks a lot
ssisexcel
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sqlaj 1 avatar image
sqlaj 1 answered
Powershell is an option for what you want to do. Have you looked at that? I have a job running every morning sending me a excel document with all failed jobs from all my servers. Take a look here for some basics. http://blogs.technet.com/b/heyscriptingguy/archive/2013/04/03/excel-spreadsheets.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

timmywest avatar image
timmywest answered
Work with excel files thanks to .xlsx repair tool Solution will suggest you some effective ways for solving given problem [ http://www.xlsxrepairtoolbox.com][1]/ [1]: http://www.xlsxrepairtoolbox.com/
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.