sql server dts: problem creating DTS package -- sql server dts

problem creating DTS package

Mohan
11/30/2005 7:42:25 AM

sql server dts: 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

Re: problem creating DTS package

Allan Mitchell
11/30/2005 9:40:37 PM

If you follow this article how do you get on and if it fails where does
it fail?

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)

Allan

[quoted text, click to view]

Re: problem creating DTS package

Mohan
12/1/2005 7:46:16 AM

thanks for the reply

The problem occurs in page 11 of the tutorial. When i click on the
destination tab, I see the column in the Define Column window but when
i click Execute nothing happens. Since there are no columns in the
destination, the tranformation fails.

I think its because of the number of columns i am selecting. Cause it
works fine for tables with 15-20 columns. The table i am trying to
transfer has 77 columns.

Re: problem creating DTS package

Allan Mitchell
12/2/2005 2:27:09 PM

Hello Mohan,

OK then what Service Pack are you using?

Is it 3 (760)?

Allan

[quoted text, click to view]

Re: problem creating DTS package

Mohan
12/5/2005 10:59:40 AM

[quoted text, click to view]

yes

Re: problem creating DTS package

Darren Green
12/5/2005 10:30:08 PM

[quoted text, click to view]

What I suspect Allan is getting at, is there is a bug in SP3. If you are
running SP3, then you should have at least applied the security roll-up,
which includes a fix for this.

Better still get SP4. Remember you should also patch clients, not just
the server.

FIX: DTS Designer may generate an access violation after you install SQL
Server 2000 Service Pack 3
(http://support.microsoft.com/default.aspx?scid=kb;en-us;814113)

--
Darren
http://www.sqldts.com

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.