Tag: SQL Server

Why Debugging is Greyed Out for SSIS Packages

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 …

Continue reading

Importing Data From Oracle to MS SQL Server Databases Via SSIS

If you’ve been following the blog then you might remember that I have had a couple of failed attempts (first article and second article) at getting connectivity going between an Oracle database as a source and a Microsoft SQL Server database as a destination. Not to be dissuaded from finding a solution I have found something that I have …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

64-Bit Windows and ODBC Drivers

A slightly more technical article for today but something worth mentioning. At work, I am attempting to get a direct connection between MS SQL Server 2008 and an Oracle database. Some might say that such connectivity would bring about the end of the world or a hole might open in the ground and swallow me …

Continue reading