BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution
This is the forum to discuss the Wrox book Microsoft SQL Server 2008 Integration Services Problem-Design-Solution by Erik Veerman, Jessica M. Moss, Brian Knight, Jay Hackney ; ISBN: 978-0-470-52576-0
You are currently viewing the BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
All packages were created using VS2008 and SQL Server 2008 with SP1. I was able to open up a sampling of packages successfully. Could you please let us know which package is giving you trouble?
Hi trying to open the
DimProduct.dtsx
and double clik on Dim Product Category task
and got exception on
Problem signature:
Problem Event Name: APPCRASH
Application Name: devenv.exe
Application Version: 9.0.30729.1
Application Timestamp: 488f2b50
Fault Module Name: msdds.dll
tried:
- ssis offline mode
-packgeruns64bit off in prj properties
-bids as admin
-bids in compatible xp3 mode
-changed the data-source to my sql instance (changing the xml code of the package)...
no way
Mario
A few things to try:
1. Make sure you have the latest SQL Server client tools installed installed on your machine.
2. Uninstall and reinstall BIDS.
3. Check to see if any other packages produce the same error.