RE: USE Query to export

Tech-Archive recommends: Fix windows errors by optimizing your registry

Yes, you can do this no problem.
Looks like you have put the TSQL query code in the data pump task but not
checked each tab to set destination and transform mappings. Also, you'll
need to provide an alias for any fields that are being changed/trimmed in
your query.

"Kalyan" wrote:

> 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
.

Relevant Pages

  • 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)
  • USE Query to export
    ... Is it possible to use query in DTS to export to Text file. ... DATA PUMP TASK REQUIRED TRANSFORMATION TO BE SPECIFIED. ... I want to trim varchar field before export to TEXT file. ...
    (microsoft.public.sqlserver.dts)
  • Summary : password expiry notification
    ... Thanks all for responding to the query. ... The scpirt is configured as suggested by Kalyan and working fine. ... Start your day with Yahoo! ...
    (SunManagers)
  • Re: Network management as a means of providing network security
    ... kalyan wrote: ... actually i am an student doing my masters. ... about the below given query. ...
    (microsoft.public.windowsxp.network_web)