Microsoft SQL Server forum - problem creating DTS package

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

problem creating DTS package

Mohan

2005-11-30, 11:23 am

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

Sponsored Links