sql server dts: hi,

I'm trying to import data from SQL Server to Excel. I've noticed that
when designing my DTS package, my excel file should already have predefined
columns for transformation. My problem is that, the number of columns i need
to import to the excel file is dynamically changing depending on the
maintained data. How can i possibly do this? Thanks in advance.

rgb

Hi ,

If I understand correctly, you may want to transfer data from SQL to Excel
with DTS package. We can use DTS Designer to create a DTS package. After
creating a Source Connection and Destination Connection and Transform Data
Task, double-click the Transform Data Task, select the disired source
table/view, click destination tab, click button Create, click OK, now you
have created a new destination table.

Does this solves your problem?

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
William Wang
Microsoft Partner Online Support



--------------------
| From: "gb" <a@a.com>
| Subject: Import SQL Server Data To Excel
| Date: Tue, 29 Jul 2003 15:44:05 +0800
| Lines: 14
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <e7Zp1UaVDHA.2004@TK2MSFTNGP11.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.dts
| NNTP-Posting-Host: 203.177.53.14
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.dts:36712
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| hi,
|
| I'm trying to import data from SQL Server to Excel. I've noticed that
| when designing my DTS package, my excel file should already have
predefined
| columns for transformation. My problem is that, the number of columns i
need
| to import to the excel file is dynamically changing depending on the
| maintained data. How can i possibly do this? Thanks in advance.
|
| rgb
|
|
|
|
|
|