SQL Server Integration Service 入门(SSIS 入门)

SSIS ABC

SSIS ABC.............................................................................................................................................................1

1. How to create and modify SSIS package..........................................................................................................2

1) Create a SSIS project....................................................................................................................................2

2) Modify SSIS Package.................................................................................................................................19

2. How to debug SSIS package...........................................................................................................................19

1) Create user variables...................................................................................................................................19

2) Change Task 3............................................................................................................................................20

2) Add SSIS run library..................................................................................................................................25

3) Add vb.net code to call SSIS......................................................................................................................26

4. How to pass parameter to SSIS package from .net program..........................................................................28

5. How is the error control in SSIS.....................................................................................................................28

1. How to create and modify SSIS package

1) Create a SSIS project

1> Click SQL Server Business Intelligence Development Studio(From: Start -> programs -> SQL Server

2008 -> SQL Server Business Intelligence Development Studio), Microsoft Visual Studio is been

opened. Click File Menu->New ->Project, Assign the project type is Business Integration project, then

select Integration Services project template.