Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DTS Package, Control name of tab in .xls file Expand / Collapse
Author
Message
Posted Thursday, December 13, 2007 1:23 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 7:17 PM
Points: 28, Visits: 300
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
Posted Friday, December 14, 2007 4:08 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 07, 2014 5:31 AM
Points: 1,012, Visits: 1,315
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 »

Add to briefcase

Permissions Expand / Collapse