Hi all.
We are using the DTS to get data from one table or SELECT into a .txt file.
Both fixed and separated. Our problem seems to be that when we get about
20-30 columns the DTS wizard shuts down unexpectly. We do get this at our
place and at our customers place. Is there any limitations on how many
columns we can export or is there any limitations on the total size of the
row or anything like this?

We have tried all the obvious tests. Extract for table directly, for SELECT,
changing columnordrer, columntypes, .txt types, datatypes and all other
tests we could come up with. It always stopes when we add one more column
after a while. The number is not consisten, but it sure hangs the EM after
adding some new columns.

Thanks all.

geir

did you tryo map fields from source to desctination table ?


"Geir Holme" <geir (AT) multicase (DOT) no> wrote

How about this-

FIX: DTS Designer May Generate an Access Violation After You Install SQL
Server 2000 SP3
(http://support.microsoft.com/default...b;en-us;814113)


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

"Geir Holme" <geir (AT) multicase (DOT) no> wrote