Here is a quick tip for those using SSIS packages with Microsoft SQL Server. If you use the data import wizard in SQL Server and save a copy of the SSIS package used to import data you might want to reuse that package to load more data in the same format. However, once you’ve loaded …
Tag: SQL Server
Nov 21 2012
Scraping HTML Tables into SQL Server Using SSIS
At work, I am attempting to scrape a table off an intranet webpage so that I can import its contents into Microsoft SQL Server so I can obtain more frequent updates for a small but critical subset of data that I would normally only receive once a day. Using this information I would also be …
Sep 29 2012
Attunity, MS SQL and Oracle – Back to the Drawing Board
Earlier this week, I shared my intention to try and use Attunity to satisfy my requirement to get MS SQL Server to connect to Oracle to facilitate the transfer of data from various databases. Unforuntately for me this idea was stopped in its tracks because the Attunity connectors are designed to be used with MS …
Sep 27 2012
An Alternative to Connecting MS SQL Server to Oracle
For a little while now I have been trying to get MS SQL Server 2008 R2 on Windows Server 2008 R2 64-bit to connect to an Oracle 10g database but have run into some issues doing so with some other more complicated solutions. My approaches to date have involved extra Oracle client software and working …
Follow Us!