That was deviation towards the world of BI. I was helping my co-worker to build a SSIS Package to import the data from AS400 into SQL Server.
At first I selected OLE DB Source component for getting the data but started getting odd errors of driver compatibilty. Then I read that there is a newish driver called DB2OLEDB which unfortunately works only on Enterprise/Developer Editions ,so I had only Standtard...
After some investigations I solved the problem by choosing DataReader Source control and selected ODBC driver for Net.Providers. It looks obvious for experienced BI consultants but for me, who rarely use SSIS, I felt great when co-worker was so happy to get all the data:-))
Sunday, October 18, 2009
Subscribe to:
Post Comments (Atom)
1 comment:
christian louboutin christian louboutin cheap christian louboutin sale christian louboutin discount christian shoes christian louboutin shoes designer handbags louis vuitton handbags replica handbags ugg classic tall ugg classic short ugg ultra tall boots christian louboutin boots MBT shoes discount MBTshoes ugg classic cardy boots ugg boots Tory Burch Shoes Giuseppe Zanotti Shoes louboutin ugg boot
Post a Comment