SQL Server 2005General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the SQL Server 2005 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
I have a transformation that processes 8000+ records. The transformation goes 95% green. I still have about 4 yellow tasks. I have tried setting the engine thread to a variety of Number including the Max and the default of 5. I get the same results.
i have a number of Unions in the transformation. What you recommend to in way of settings to finish the transformation?
Are you saying that the Transformation does not complete? What error does it generate, if any? 8000+ records should be easy for SQL Server, and changing the threads won't really get you anything. I would start by looking at your syntax.
That is correct it does not complete. I have about 4 or 5 task that are still yellow. There are no errors. I've cleaned up all the DTS warnings in regards to Union messages. I've reread chapters 10 and 11 from SQL SERVER 2005 Integrations Services hoping to get a light bulb in the optimazation area. I have a varity of unions in the transformation. Maybe I should review my tree struction and place more unions throughtout the process?
Thanks, I'll double check the unions. The Wrox SQL Server 2005 Integration Services recommends putting unions before natural balancing points in the transformation. Is there a timeout variable that can be lengthened?