SP3 and DTS crashes
-
Hi all,
On one of our development machines we cannot open existing DTS packages after installing SP3. When we try to open a package, the application crashes and just goes away.
Any ideas??
-
Do these DTS packages have connections to text files where the text files have more than 255 columns in a row?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
No, some odd 100 fields. It's an export of a table to a delimited text file. The package is created using the wizard. No special stuff, just clicking 'Next...' all the time.
This happens consistently on all packages, being it old or newly created packages.
-
Okay, here goes with the standard Microsoft answer: Did you try reapplying the service pack? Perhaps something didn't get registered properly.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
Been there, done that
Reapplied SP3 for Win2K and SP3 for SQL2K (in that order), but the problem still is not solved.
BTW, the problem persists on the production server at the site.
-
Solved the puzzle, but haven't got a solution yet.
On 28th of January, a post appears on the microsoft.public.sqlserver.dts forum (Subject : "SQL2000 sp3 et al.") featuring some e-mail communication between a user and microsoft's Thomas Casey.
Apparently this is a known issue, but no hotfix has been released. A DLL (dtsui.dll) has to be replaced, but I've not gotten a hold of it (yet).
-
fyi check http://support.microsoft.com/default.aspx?scid=KB;EN-US;814113
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Woo hoo! They finally released something on it, though it doesn't give info as to what causes the issue... oh well.
I think this is the GUI fix to resolve DTS packages that reference text files with > 255 characters in a row.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
Must have been for Valintines day :))
I've got a sp3-dts problem in a transfert from db2os390 to sqlserver(local). Still working on it with MS. I'll keep you informed.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I've installed sql2ksp3 with success, but DTS gave me headaches. All worked but those connecting to DB2 UDB V7.2 (rtm version). Contacted pss and it took a couple of days before the problem had been deducted to a flaw in the DB2 UDB V7.2 ODBC driver. After installing the latest fixpac for udb-client that worked fine, but I had to alter _all_ the DB2-OLE-db connections to be able to show the properties without getting an error (unspecified).
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply