DTS Package, Control name of tab in .xls file

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » In The Enterprise » DTS Package, Control name of tab in .xls file...

DTS Package, Control name of tab in .xls file

Rate Topic

Display Mode

Topic Options

Author

Message

Edward Shaw

Posted Thursday, December 13, 2007 1:23 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, February 04, 2013 4:12 PM
Points: 28, Visits: 290

I have a DTS package (sql server 2000) that I need to create where it is exporting data to an excel sheet. When I create the step it runs fine but the name of the tab in the .xls worksheet ends up being the same name as the worksheet. Is there anyway to control this through the DTS job.

Thanks.

Post #433056

Renuka__

Posted Friday, December 14, 2007 4:08 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 8:36 AM
Points: 966, Visits: 1,252

Hi,

If I have understood your requirement correctly, this should work:

Under the destination tab of data transformation task, the connection shows " , below that it says "Table Name", there I think you can choose "Create" and use the name that you want.

Renuka__

Renuka__

Post #433224

« Prev Topic | Next Topic »

Permissions