Microsoft Inside Ole 2 Kraig Brockschmidt
Publisher: Microsoft Press

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. The question I have is how to pull data from mySql and directly insert into Sql Server table? I was unable to do it since MS SQL provides only two non SQL Subscriptions/Publishers options. The Strategic Technology Microsoft introduced its ActiveX technology to developers in 1996 as a means. If your OLE DB Source and OLE DB Destination have green circles with check signs inside, then there's a good chance your data transferred without issues. Let's try and create MySQL linked Server on MS SQL . The connecting arrow should display 5 rows. Luckily, Microsoft is ahead of the pack in this regard with its in-memory solution since it holds the world ETL record for moving in excess of 2 TB of data per hour (650+ MB/second). It should come as no surprise that SSIS is depended on by more . Buy Book Inside Ole 2: The Fast Track to Building Powerful. OLE2 is a container format synonymous with Microsoft Office files, although it is used for many other purposes. Of present-day applications development. Great article, thank you very much.