p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 (http://p2p.wrox.com/forumdisplay.php?f=242)
-   -   Need a SSIS Survival Guide... (http://p2p.wrox.com/showthread.php?t=42736)

sqlsquirrel May 18th, 2006 12:07 PM

Need a SSIS Survival Guide...
 
After going through the book and attempting to adapt it to my everyday use of SSIS I have come to realize that the book does not offer insight into trouble shooting and getting solutions fast.

For example, when converting a SQL Server 2000 DTS package to a SSIS package. After converting it successfully, you try to run the package manually in the SSIS environment it will run to success. When you schedule the package in a Job the package fails due to invalid login. So I had to hunt and hunt and referenced the book several times... but no information on how to resolve this issue. I discovered on my own that you need to create a XML Configuration File from the Package Configuration Wizard and pass the username and password to it.

I think it would be great to have a "survival guide" sort of speak so that we can reference issues like this really quick and get the solution we need. The example I gave above is just one example.

The book is great in helping with the "learning curve" and giving good solid background information.

I would be interested in knowing how other people found this book useful in troubleshooting.

Cheers!

sqlsquirrel


All times are GMT -4. The time now is 09:04 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.