USE Query to export

From: Kalyan <Kalyan@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 23 Jun 2005 10:05:02 -0700

Is it possible to use query in DTS to export to Text file.
I tried it, gives error msg.

DATA PUMP TASK REQUIRED TRANSFORMATION TO BE SPECIFIED.

I want to trim varchar field before export to TEXT file. That is why i used
query
with ltrim and rtrim on that particular field.

thanks
kalyan
.

Follow-Ups:
- RE: USE Query to export
  - From: PaulaPompey

Prev by Date: RE: DTS Job failure
Next by Date: Re: Steps run individually but not when run as DTS
Previous by thread: Remote DTS
Next by thread: RE: USE Query to export
Index(es):
- Date
- Thread

Relevant Pages

RE: USE Query to export
... Looks like you have put the TSQL query code in the data pump task but not ... "Kalyan" wrote: ... > DATA PUMP TASK REQUIRED TRANSFORMATION TO BE SPECIFIED. ...
(microsoft.public.sqlserver.dts)
Re: perform a two dimensional lookup
... I know how to dynamically set the query ... for lookup in the work flow activex of data pump task. ... requirement is to dynamically set the query in the transformation ... For doing this while executing the data pump task, ...
(microsoft.public.sqlserver.dts)
Re: Gobal variable in dynamic properties
... You can use a global variable in a query within the Exec SQL ... the Data Pump task and the Data Driven Query task. ... parameters in a query fro a Dynamic Properties Task assignment. ...
(microsoft.public.sqlserver.dts)