Hello

I created a simple dts package that ports data from one view to a txt file
(sounds simple )
I created two datasources, one for the sql server and one for the txt file.
Now comes my problem, I use sql query to select wich data to port to the txt
file, the select statement is like this: (scrambled)
--- beginn of select statement
SELECT 1111111111111,
2222222222,
3333333333,
444444444444,
55555,
66666,
7777777777,
88888888888888888,
9999,
00000000000,
aaaaaaaaaaaa,
bbbbbbbbbb,
ccccccccccccccccc,
ddddddddddddddddd,
eeeeeeeeeeeeeee,
ffffffffffff,
gggggggg,
hhhhhhhhhhhh,
iiiiiiiiiiiii,
jjjjjjjjjjjjjjj,
kkkkkkkkkkkkkkk,
lllllllllllll,
mmmmmmmm,
nnnnnnnnn,
ooooooooooooo,
pppppppppppp,
qqqqqqqq,
rrrrrrrrrrrrr,
ssssssssssssss,
tttttttttttttttt,
uuuuuuuuuuu,
vvvvvvvvvvvvv,
xxxxxxxxxxxxxxxxx,
yyyyyyyyy,
zzzzzzzzzzzzz,
x1x1x1x1x1x1x1,
x1x1x1x1x1x1x1x1x1x1x1x1x1x1x1,
x2x2x2x2x2x2x2x2x2x2x2x2x2x2x2,
x3x3x3x3x3x3x3x3x3x3x3x3
FROM database.dbo.my_view
WHERE (qqqqqqqq = '1234')
--- end of select statement
this query runs fine under query analizer but it does not allow me to select
any columns to export to the txt file.
Now for the fun part, I tried to shrink the select statement by selecting
only 21 lines, then it worked fine, as soon as I added the next column it
stops working and even when I click define column (in a transform data task)
sql server enterprise manager shuts down. I tried to add another column to
be sure that the column itself was not the problem and the same thing
happend, so my conclusion is that it seems like there is some limit on the
transform data task on selectable columns.
Is this correct?

Best regards
GauiC

This is a bug introduced in SP3

There is a fix in this Hotfix

814113 - FIX DTS Designer May Generate an Access Violation After You
Install SQL Server 2000 SP3
http://support.microsoft.com/d-efaul...;EN-US;8141-13

This was originally only available as a hotfix direct from PSS, but as
per the KB article it has been included in the latest security patch
which saves you a PSS call-


821277 - MS03-031:Security Patch for SQL Server 2000 Service Pack 3
http://support.microsoft.com/d-efault.aspx?kbid=821277




"news.microsoft.com" <gauic (AT) hotmail (DOT) com> wrote

I have installed the hotfix (it restarts the SQL service)
But this is still a problem.
I even tried to recreate the package but all the same.
So this is still a problem.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Don't know then. From your description this is definitely the problem highlighted in my previous reply.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"news.microsoft.com" <gauic (AT) hotmail (DOT) com> wrote

Allan Mitchell wrote:
I tried this again and it worked.
The problem was that I needed to run the hotfix also on the machine that
I was connecting from, it was not enough to run it only on the server
itself.
Thanks for the help