Install Northwind database on SQL Server 2008 R2

I have a lab for testing Bulk Insert Task in SSIS. According to this example, it need to access Northwind Database.
Due to my environment is SQL Server 2008 R2,it has already never exist this naming database since SQL Server 2005. So I want to know whether is can install Northwind sample database on SQL Server 2008 R2.

I search this database from Microsoft Website and find where it can be downloaded from
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23654
After download,extract and execute “SQL2000SampleDB.msi” by following the wizard, the extracted files will be put on “C:\SQL Server 2000 Sample Database”.For quickly complete this job, I will copy “Northwind.MDF” & “Northwind.LDF” to the SQL Server default database file location as “C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA”
Open Microsoft SQL Server Management Studio and Right-Click Database, select “Attach” item in menu so that Attach Databases windows will show up now.
In Attach Database window,click “Add” button, select “Northwind.MDF” next to click “OK” button to complete this selection.
So does that the Northwind database will be mounted and online now.

Simple Execute SQL Task in SSIS (part 2 of 2)

(4).Configure the second “Execute SQL Task” object
Right-Click the second “Execute SQL Task” to select “Edit…” in menu or Double-Click “Execute SQL Task”
Select the right value as Connection, SQLSourceType, FileConnection next to click “OK” button
(5).Create SSIS Variable and configure the related setting
Create Variable
In main menu, select “SSIS” –> "Variables”
Click Control Flow surface anywhere next to click “Add Variables” button
Key in “strFile” Name and select “String” Data Type
Configure Foreach Loop Container
Right-Click the “Foreach Loop Container” to select “Edit…” in menu or Double-Click “Foreach Loop Container”
Click “Collection”, select “C:\SQLFILE” Folder and assign “ *.sql ” Files
Click “Variable Mappings”, select “User::strFile”  variable and click “OK” button
Configure Connection Manager
Click “SQLFILE” Connection --->  Managers, Expresssions ---> “…” button
The property Expressions Editor will show up
Select “Connection String” in Property and click “…” button
Drag and Paste “User::strFile” from Variables to “Expression” surface next to click “OK” button
So does that “@[User::strFile]” will show on Expression now.
(6).Create file format with SQL languageIn “C:\SQLFILE” path, create “three” SQL Server Query File
In each file, the content is as follows
(7).Build and Start with debugging
When we execute “Build and Start” this SSIS package, the result is successful.
In Microsoft SQL Server Management Studio, the table “TestSQLTask” will be created and the value will be inserted now.

Simple Execute SQL Task in SSIS (part 1 of 2)

I want to do a SQL Task in SSI to realize “Execute SQL Task” mechanism. The scenario is
  (i). The first SQL Task is for creating table and import data if the table doesn’t exist
  (ii). The second SQL Task import data by executing sql language in Foreach Loop Container
For do it, I will use the AdventureWorks as example database.
(1).Design Control Flow
As before, I firstly open “SQL Server Business Intelligence Development Studio” and create a new Integration Services Project.
Drag the first “Execute SQL Task” object from Control Flow in left tool to designer surface
Drag the “Foreach Loop Container” object from Control Flow in left tool to designer surface
Drag the second “Execute SQL Task” object from Control Flow into the inner “Foreach Loop Container” object
Drag a green arrow in the first “Execute SQL Task” to “Foreach Loop Container” object
So does that I have already finished the initial “Control Flow Design”
(2).Create Connection ManagerOLE DB Connection
Right-click Connection Manager surface next to select “New OLE DB Connection…” in menu
Click “New” button
Select the right value as Provider, Server Name, Authentication, Database Name and click “OK” button if “Test Connection” is normal.
Finally, it will create a new Connection Managers as “TEST-SQL-03.AdventureWorks”
File ConnectionRight-click Connection Manager surface next to select “New File Connection…” in menu
Select the right value as Usage type, Folder and click “OK” button
Finally, it will create a new Connection Managers as “SQLFILE”
(3).Configure the first “Execute SQL Task” objectRight-Click the first “Execute SQL Task” to select “Edit…” in menu or Double-Click “Execute SQL Task”
Select the right value as Connection Type, Connection, SQLSourceType and click SQLStatement button
Write down T-SQL language for creating Testing Table if it no exit and inserting some value to this Table

Lookup Transformation in SSIS (Part-1)

When I design a ETL package for importing Oracle some data to SQL Server by SQL command, that is “Select data from Oracle in the time duration”, it is successful for me to do it.

Data Source View

Execute Debug mode and it is successful

If repeat the above step “start debugging”, the same data will be import again. That is duplicated data in database now.

View Imported data by SQL command

How to resolve this problem? I want
"If Imported data is the same as SQL data and one field is corrected, this record will overwrite the SQL data.”
"If imported data is the same as SQL data but no field is changed,this record will be ignored.”
"If imported data is new,the record will insert directly it into SQL database.”
For the above target, I will correct the original SSIS Package for satisfying the necessity.

(1).Add "Lookup" Data Flow Transformation
In Solution Explorer, select the original SSIS Package as "Package Lookup.dtsx" next to click "Data Flow" tab.

Right-Click the green line between "Data Conversion" and "SQL Server Destination" next to select "Delete" in menu.

Click the Data Flow Transformation as "Lookup" in the left panel

Drag & Paste it to the empty space of Data Flow Task.

Click green arrow in Data Conversion

Drag & Paste it to Lookup

So does that it will create a green line between Data Conversion and Lookup

Click a green arrow in Lookup

Drag & Paste it to  SQL Server Destination

When you release mouse, the "Input Output Selection" Windows will show up.

In Output field, select "Lookup No Match Output"

Click OK button

The Data Flow will be built now.