problem creating DTS package

Hi,

I am trying to create a DTS package wherein the data from the sql
server is transfered to a text file. I am using the Transform Data Task
to transfer the data.In Transform Data task properties, I build the
query and able to preview the data but when i click OK in the Transform
Data task properties screen I get the following error.

"To continue , define transformations. You can make changes to the
default transformations"

I am not able to define the transformations. Has anyone had this
problem and know  a way to resolve it. I would appreciate if anyone
could help me.

Thanks
MB

are you working on the server or throught the EMC remotely?

are you working on the server or through the EMC remotely?

Mohan  wrote:
> Hi,
>
> I am trying to create a DTS package wherein the data from the sql
> server is transfered to a text file. I am using the Transform Data Task
> to transfer the data.In Transform Data task properties, I build the
> query and able to preview the data but when i click OK in the Transform
> Data task properties screen I get the following error.
>
> "To continue , define transformations. You can make changes to the
> default transformations"
>
> I am not able to define the transformations. Has anyone had this
> problem and know  a way to resolve it. I would appreciate if anyone
> could help me.
>
> Thanks
> MB
>
You need to define the transformations first before you can click OK.
The text file must be defined with column names and then the
transformations can be assigned.

I am actually using the remote connection to work directly on the
server.
i was able to get it to work if i selected some of the columns, but not
all. Is there a limit on the number of columns?
Let me explain in more detail.

When i am setting up the transform data task, I build the query and
then go to the destination tab. I click the Execute button to define
the columns for the destination.
The problem is that when i select all the columns from the table then
nothing happens when i click Execute. There are no columns defined and
when i click on the Define Columns button it gives an error and
terminates Enterprise Manager.

I am not sure whats going on. Really appreciate your help

Thanks
MB

Mohan  wrote:
> I am actually using the remote connection to work directly on the
> server.
> i was able to get it to work if i selected some of the columns, but not
> all. Is there a limit on the number of columns?
> Let me explain in more detail.
>
> When i am setting up the transform data task, I build the query and
> then go to the destination tab. I click the Execute button to define
> the columns for the destination.
> The problem is that when i select all the columns from the table then
> nothing happens when i click Execute. There are no columns defined and
> when i click on the Define Columns button it gives an error and
> terminates Enterprise Manager.
>
> I am not sure whats going on. Really appreciate your help
>
> Thanks
> MB
>
What service pack is SQL Server running on?  That may be part of the
issue if you have a large amount of columns to export.

Its running on SP3.