Tag Archive: SSIS

Apr 21 2013

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 »

Apr 01 2013

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 »

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 …

Continue reading »

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 …

Continue reading »