>>>> Subject: [NF] Anybody using SSIS under MSQL 2005? If so, what do you think about it? <<<<
I have been for years creating a number of DTS packages under SQL 2000 (at the day job). For the last 6 months or so, I have been re-writing the logic from these DTS packages into SSIS SQL 2005 (now SP2)... SSIS is both more powerful, and more picky on a number of issues... 1. Just using the import wizard, which fires off a SSIS wizard, more likely than not will have some issues when attempting to pick up a BCP file for further processing into a table. Often, column truncation issues must be dealt with... 2. There are a lot of new containers - meaning not allot of separation between the "Control Flow" and the "Data Flow" containers - where logic like a SQL task can be expressed in either place - but no specific requirements exist to define the boundaries... Anything in particular? Cheers John C. Gunvaldson www.fox-net.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
