Products Resources Support About Us

Rocket Software

Using SSIS to extract data from Unidata

Does anybody use SQL Server Data Tools / SQL Server Integration Services for extracting data from Unidata? We have legacy packages that use the deprecated UniOLEDB driver but when trying to upgrade them to newer versions of SQL Server I’ve found there are some issues with the driver and the modern versions of SQL Server Data Tools (e.g. date selects don’t work). From the blogs on Rocket site it appears they are now pushing the U2 Toolkit .NET Provider which I am trying to use, but I have experienced some frustrations with it so far compared to the UniOLEDB driver.

What drivers does everybody else use for ETL/extracting data in SSIS?

If you use the UCI option to connect to UniVerse you should find it easier. SSIS adds it’s own schema checking layer.