I am trying to populate a csv file with a stored procedure
that returns result set. Everytime I do that Enterprise
manager crashes.
Is there any known SP3 bugs/issues which cause a problem
with DTS?
Environment-
OS- Win 2000 Adv Server SP4
SQL Server 2000 SP3

Steps
1: DTS --> new package
2: set up source connection - udl file pointing to the
local sql server
3: set up destination - text file
4: set up transformation
5: In the source tab of transformation select "Sql Query"
and enter the name of the stored procedure
6: In the destination tab there will be pop up window with
column names off all the columns from the stored procedure
result set.
click on the Execute button and all the source column
are supposed to be populated. This doesn't happen any
more. the source column
window is empty. Furthermore when you click on Define
columns again Enterprise manager crashes or exits abruptly

I was wondering if this has happened with anyone. Is it a
known bug. I used to do it all the time before. I tried
doing this from
DTS menu available in the Tools menu of Enterprise
manager. No issues there works fine. I can even populate a
table doing the above 6 steps
but when I try to do the csv file it crashes.

Known problem with SP3.

You need to give MS PSS a call and log it. They will send you a hotfix

http://support.microsoft.com/default...en-us%3B814113

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Ali" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks Allan. I'll forward this information to the DBAs
and let fix install the patch for us.

Appreciate your help!

I was able to fix the problem after I installed MS03-031:
Cumulative Security Patch for SQL Server and another patch
which it asked us to.
1.) http://support.microsoft.com/default.aspx?scid=kb%3Ben-
us%3B814113
2.) http://support.microsoft.com/?kbid=826161

Thanks for the Help!