Monday, February 29, 2016

Create script task in SSIS

One of the efficient way to extend SSIS control flow is to create  script task. 

Need : We can perform custom task that cannot be performed using default task


Steps involved


1) Select the script task from the toolbox

 



2) Drop the script task to the control flow

 

3) Double click the script task and a window would pop up as shown below. We need to click on the edit script button


4)Look for the section where it specifies //TODO: we need to add our custom code here.




















5)

2 comments:

  1. Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important.Project Center in Chennai

    Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.

    Spring Training in Chennai

    The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete