DTS to text 1

[Newbi1]

I have to generate a text file for an application to pick up. I have the query written, however cannot execute the query in the DTS package. Also tried creating a view, but i cannot find the view in the list of source data to go to text.

Here is my query:

select ('"' + p.wbs1 + '"'),('"' + p.name + '"'),('"' + p.ProjMgr + '"'),('"' + e.FirstName + ' ' + e.LastName + '"')
from pr as p inner join em as e on p.ProjMgr = e.Employee
where p.wbs2=' ' and p.status='A' and (p.chargetype='P' or p.chargetype='R')
order by p.name

The error I keep getting is:

The data pump task requires transformations to be specified.

How do i do this without having to create a new table and make 2 DTS packages?

 

[JayKusch]

What are you trying to accomplish? This query would not even work in Query Analyzer.

Try this in Query Analyzer then in your DTS package.

select p.wbs1,
       p.name,
       p.ProjMgr,
       RTRIM(LTRIM(e.FirstName)) + ' ' 
         + RTRIM(LTRIM(e.LastName))
from pr as p 
inner join em as e 
on p.ProjMgr = e.Employee
where p.wbs2=' ' 
and p.status='A' 
and (p.chargetype='P' or p.chargetype='R')
order by p.name

Thanks

J. Kusch