Creating Package

For creation of a basic package, one easy way is to use the SQL Server Import and Export Wizard. However Business Intelligence Development Studio (BIDS) is to be used for creation of more sophisticated packages. IS management is centred on packages and a DBA has to basically run packages and other package-specific tasks including creating and storing.

A Sample Package

For example, a package can be created in a study for vaccination of patients to import from biometric monitors data which are comma-delimited. The number of a patient and measurements of a series of data like the temperature, pulse, respiration and blood pressure of the patient form the biometric data.

Creating Package for Importing Data

The BioData or the blank database is already there in a server (say SQL01) on the SQL Server 2005. For easy scheduling of biometric data to be periodically refreshed, a package is needed for importing the data. The steps for creating this package are:

1. Open SQL Server Management Studio.
2. Connect to the SQL01 SQL server Database Engine.
3. Expand the Object Explorer Databases folder.
4. Right-click on BioData database.
5. SelectTasks, Import Data.
6. Click Next.
7. Select Flat File Source From the Data source drop-down.
8. Enter the source data filename.
9. A warning is shown in the messages window that says, "Columns are not defined for this connection manager."
10. Check the box Column Names in the first data row.
11. Click Next.
12. Click Next for leaving the destination defaults.
13. Click Edit Mappings.
14. Check the box Drop and Re-create Destination Table. Each time the package is run, this setting overwrites the table.
15. Click OK.
16. Click Next.
17. Check the box Save SSIS Package and click Next. This is for saving the package to the SQL Server.
18. Enter a name for the package.
19. Click Next and then Finish.