Microsoft Inside Ole 2 Kraig Brockschmidt
Publisher: Microsoft Press

Published May 17, 2013 | By Microsoft Support Type in the SQL server name where the Analysis Cubes SSIS packages reside into the Server field. This is a great improvement over the old OLE notes container. This method allows one to automatically see the 2. Get the latest inside scoop directly from the Product Marketing team! The question I have is how to pull data from mySql and directly insert into Sql Server table? Let's try and create MySQL linked Server on MS SQL . Double-click the icon inside the OLE DB Source entity. @srvproduct='Microsoft OLE DB Provider for DB2',. @provstr='NetLib=TCPIP;NetAddr=XXX. Great article, thank you very much. I was unable to do it since MS SQL provides only two non SQL Subscriptions/Publishers options. However I created the linked server through which I can access Specifically, an OLE DB data source points to the specific database that can be accessed using OLEDB. And me being a bigger fan of Microsoft than IBM, I decided I would go the route of connecting SQL Management Studio and SSIS into the DB2 databases to extract the data.