Browse by Tags
All Tags »
SSIS (
RSS)
Microsoft does not provide any drivers to connect to Sybase. Sybase have their own drivers (only 32 bit) but they do not have 64bit. I cant understand why they dont provide the 64bit drivers. Flipside of that why dont Microsoft provide any drivers for...
As discussed before if you have a type 2 dimension and late arriving facts you are in a messy situation. Most of us do it using SQL Statements. Lets see we could do this using SSIS. One of my c olleague the following way, which seems to be a very good...
One of my c olleague asked us how are we currently handling Late Arriving Facts against Type2 dimension within SSIS. My answer was we don’t. Well I do ask the client do you have late arriving facts. Most of the time they don’t know what is late arriving...
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...