blogs.conchango.com

There was some great news this week for SSIS developers that are building solutions involving databases other than SQL Server; Microsoft will, later this year, be releasing new connectors for Oracle, Teradata and SAP BW. Check out Darvey Lavender's announcement on the SSIS connectivity wiki or read Matt Masson's blog entry for more details. I ...

I'm posting this largely as a future reminder to myself but in case anyone is interested TDWI have posted a comparison of SSIS and Oracle Warehouse Builder. The article also makes a nod towards comparisons with pureplay vendors such as Informatica and (to a lesser extent since their purchase by IBM) Ascential. Thanks to Duane Douglas for ...

Those of you that are using SSIS in conjunction with Oracle will have (or should have) read Donald Farmer's blog post that details some of the issues that you need to be aware of. Donald himself states ''I do not expect that Microsoft will write an Oracle fast loader - .... But on the other hand I do fully expect that there will be excellent ...

Many customers are unhappy that SSIS performance is slow slow slow when inserting to Oracle. Donald Farmer sets outs a few of the reasons for this here: http://www.sqljunkies.com/WebLog/donald_farmer/archive/2005/03/13/8819.aspx A guy called Scott Barrett whom is fairly prevelant on the SSIS forum had some issues with this and trialled a ...

Most of the stuff I put up here is to share knowledge around a bit but every so often I use it as a dumping ground for little titbits that I don't want to forget in the future. This is one such occasion. I've been trying to access data in Oracle from SSIS via OLE DB and was getting the following warning: ''Cannot retrieve the column code page ...