Execution Patterns - SQL Server Integration Services Design Patterns - page 56

Select the sensor1-all.csv file and then click the OK button on the Open dialog
since we are accepting the Flat File connection manager defaults for the purposes of
this demo. Click the OK button to close the Flat File Source Adapter Editor.
Before we proceed, open SQL Server Management Studio (SSMS), connect to an
instance of SQL Server 2014, and create a database named TestDB .
Return to SQL Server Data Tools - Business Intelligence (SSDT-BI) and drag an
OLE DB destination adapter onto the Data Flow task surface. Rename the OLE DB
destination adapter OLEDBDest TemperatureStage and connect a data flow path
(blue arrow) between the FFSrc Temperature Flat File source adapter and the
OLEDBDest TemperatureStage OLE DB destination adapter. Open the OLEDBDest
TemperatureStage OLE DB Destination Adapter Editor and click the New button to the
right of the OLE DB Connection Manager drop-down to create a new OLE DB con-
nection manager and open its editor. When the Configure OLE DB Connection Man-
ager window displays, click the New button to open the Connection Manager Editor
window. Enter the server name and user login credentials, then enter or select the
TestDB database in the Select or Enter a Database Name drop-down. Close the editor
and the Configure OLE DB Connection Manager window to return to the OLEDBDest
TemperatureStage OLE DB destination adapter.
Click the New button to the right of the Name of the Table or the View drop-down
in the OLEDBDest TemperatureStage OLE DB destination adapter. Modify the con-
tents of the Create Table window to match the data definition language (DDL) state-
ment in Listing 2-5 .
Listing 2-5 . Data Definition Language (DDL) Create Table Statement for Destination
CREATE TABLE [TemperatureStage] (
[Date] varchar(50),
[Time] varchar(50),
[MinT] varchar(50),
[MaxT] varchar(50),
[AverageT] varchar(50),
[MinH] varchar(50),
[MaxH] varchar(50),
[AverageH] varchar(50),
[ComfortZone] varchar(50),
[MinDP] varchar(50),
[MaxDP] varchar(50),
[AverageDP] varchar(50),