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: SSIS
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 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!