I am very pleased to see Data Profiling Task is going to be part of SQL2008. I have been requesting this task since SQL 2005 TAP programme when I was at Reuters. You can read all about Data Profiling Task here . Another feature I would like to see and...
http://blogs.msdn.com/mattm/archive/2008/01/22/what-s-new-in-sql-server-2008-for-ssis-part-two.aspx
http://blogs.msdn.com/mattm/archive/2008/01/10/what-s-new-in-sql-server-2008-for-ssis-part-one.aspx Thanks Sutha
I came across something simple and annoying earlier this week. I had XML file as source with a string called "Room Hire £200". For one reason or the other I couldn't load the file via SSIS. I couldn't see anything wrong with the file. I try to open the...