Feeds:
Posts
Comments

Posts Tagged ‘Sequence Container SSIS Example’

1. Open BIDS

2. Go to Control Flow, Drag a Sequence Container Task and Three “Execute SQL Task “Component.

ssf

3. Make an OLEDB Connection

4. In first Execute SQL Task write direct SQL AS “SELECT 1”

5. In Second Execute SQL Task write direct SQL AS “create error”

***here write something that results in error

6. In Third Execute SQL Task write direct SQL AS “SELECT 1”

7. After you are done with the above steps go to properties of  “Sequence container” Shown Below
And Change TransactionOtion to “Required”

 

ss11

8.Run Package

ss12

Read Full Post »

%d bloggers like this: