Exporting to Excel

[synapsevampire]

I need to export a table to Excel and dynamically create the file name and destination, any ideas or examples?

-k

 

[gprima]

Create a DTS package. First open up a connection with the Microsoft OLE DB Provider for SQL Server. Login to the SQL server with windows authentication or SQL Server authentication, which ever is appropriate. Then select the database you need to connect to.

Next make a connection to Microsoft Excel 97-2000. Specify an excel file name. Then select a Data Transformation Task. Once you have the task in place double click on it.

In the properties dialog, choose the source table, Create the destination table and then select the transformations.

Once that is done you can run the package.

Hope this helps.

Gary

 

[DimaD]

Note: If Excel file already exist, selection "Replace records" does not work, you have to select "Delete file and create new"