DTS Error

I am having some problem creating a new DTS task or modifying an existing
one. My goal is to transfer data from a table (tableX) to a text file
(export.txt). I can not define the columns I want to transfer in the
Destination tab under the Transfer Data Task Properties. If I use the Define
Columns… button, Enterprise Manager crashes. If I try to define the column
s
manually, I get the following message:
A DTSTransferCopy must specify no columns (signifying a sequential 1-to-1
mapping of all columns) or the same number of source and destination columns
.
Please help.
ThanksHi
If you are only wanting to transfer a subset of the source tables columns
then you will need to restrict the columns in the source by specifying a SQL
query that selects the columns that your require.
John
"Emma" <Emma@.discussions.microsoft.com> wrote in message
news:088B07FA-328C-469A-A9D4-83C0A6730FE9@.microsoft.com...
>I am having some problem creating a new DTS task or modifying an existing
> one. My goal is to transfer data from a table (tableX) to a text file
> (export.txt). I can not define the columns I want to transfer in the
> Destination tab under the Transfer Data Task Properties. If I use the
> Define
> Columns. button, Enterprise Manager crashes. If I try to define the
> columns
> manually, I get the following message:
> A DTSTransferCopy must specify no columns (signifying a sequential 1-to-1
> mapping of all columns) or the same number of source and destination
> columns.
> Please help.
> Thanks
>

DTS DataPump from a Stored Procedure

Hi,

assume I have a stored proc which returns a result set. Can I use it as an Sql source query in a TransformData task within DTS ?

The goal was to pick up the result set and create Excel sheets. First I wrote VBA code in Excel, and it worked just fine with OleDb. Later, we found the corporate standard is DTS, so I attemped to set up a Task in the Package Designer Wizard ( no DTS-VBA code )

At the SQL Query box, I have entered: exec my_proc

The preview function shows the data as expected. But in the Destination Tab, I get an empty list of columns. As if DTS would be unable to recognise the column names and types if they come from a stored proc.

I used a workaround, by altering the stored proc to deposit data into a work table. But now I'm still interested to know: is this assumed to work ?Yes
Just invoque your stored procedure on your DTS. Then use the results as you want.

Paulo

Originally posted by andrewsc
Hi,

assume I have a stored proc which returns a result set. Can I use it as an Sql source query in a TransformData task within DTS ?

The goal was to pick up the result set and create Excel sheets. First I wrote VBA code in Excel, and it worked just fine with OleDb. Later, we found the corporate standard is DTS, so I attemped to set up a Task in the Package Designer Wizard ( no DTS-VBA code )

At the SQL Query box, I have entered: exec my_proc

The preview function shows the data as expected. But in the Destination Tab, I get an empty list of columns. As if DTS would be unable to recognise the column names and types if they come from a stored proc.

I used a workaround, by altering the stored proc to deposit data into a work table. But now I'm still interested to know: is this assumed to work ?