SSIS Package to Insert New Records

2197863-walker_of_the_mojave

Script it…then walk away!

The problem: Create a SSIS package that will update a table with only new records

The quick and dirty solution:…

1. Drop a Data Flow Task
2. Inside 1, Drop (in this order) an OLE DB Source, Lookup, and SQL Server Destination
3. The OLE DB Source is your select statement from data source, for example mine is:
SELECT data1, data2, data3, etc, from sourceTable
4. The lookup contains a query to compare, for example mine is:
SELECT data1, data2, data3, etc, from destinationTable
5. Configure the Error Output on the Lookup to Redirect Row
6. Connect the Red Arrow from the Lookup to your SQL Server Destination

Blocking IP Addresses – Windows Server 2003

31_Reaver

The best defense is a strong CHAINSAW SWORD!!!

First off…I wouldn’t recommend having a sql server that is accessible from the outside world.

In my case though I have a development server that I run from a partners network. Somewhere down the line some one or “some many” have run a scan and found this out. So my logs are filling up with password attempts.

Continue reading