Re: DTS Transformation Task Problem

#1

Maybe it is this problem-

814113 - FIX: DTS Designer May Generate an Access Violation After You
Install SQL Server 2000 SP3
(http://support.microsoft.com/default...3&Product=sql2
k)

"Luis Simões" <Luis Simes (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi there,
I am currently trying to put a sql server database table into a txt file
by using a dts package.

I came out with the following problem, the sql server manager gives a
fatal error because the source table have to many rows.
I am querying the table and selecting the desired fields(about 20) and
when i go to the transformation properties and make the populate it goes

everything wrong the it crashes...

Quote:

How can i transform data from the table into the text file with that
amount of columns?
I don't wanted to use activex because i need it to make the most
transparent as possible.

Best Regards,
Luis Simões

#2

Are you sure? How long is your SELECT statement? What is the error you get?
Never heard of this being a problem.

Obvious workarounds would be to use a view or a stored proc to hide it, but
I don't think it should even be a problem as you describe.

--
Darren Green
http://www.sqldts.com
"Luis Simões" <LuisSimes (AT) discussions (DOT) microsoft.com> wrote

Quote:

Ok i have come to an answer for the problem....

The SQL Select Statement was too big... What the hell what if i have
enough fields to fill the max chars for the select stm?

Any update/patch on this problem?

Regards,
Luis Simões

"Luis Simões" wrote:

Hi there,
I am currently trying to put a sql server database table into a txt file
by using a dts package.

I came out with the following problem, the sql server manager gives a
fatal error because the source table have to many rows.
I am querying the table and selecting the desired fields(about 20) and
when i go to the transformation properties and make the populate it goes

everything wrong the it crashes...

Quote:

How can i transform data from the table into the text file with that
amount of columns?
I don't wanted to use activex because i need it to make the most
transparent as possible.

Best Regards,
Luis Simões

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DTS Transformation Task Problem

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: DTS Transformation Task Problem - 08-05-2004 , 04:41 AM

Re: DTS Transformation Task Problem - 08-05-2004 , 06:22 AM