.CSV Destination Help

• tooba111

  Right there with Babe

  Points: 767

  More actions

  May 11, 2015 at 10:03 am

  #307884

  Hi All,

  Here is my question. I want to know how it is possible below question in SSIS

  Question: - Simple SSIS Package,

  1 Step: - Execute SQL Task (Truncate Staging Table)

  2 Step: - Data Flow Task (Reading data from Excel and Insert into SQL Table)

  3 Step: my- Using SQL Query as a source to create data from staging table (Populate in Step 2) and destination imine.CSV File.

  My question is, how can I stop create .csv file if Package fail in 3rd step?

  I tried to use Sequence container, but it is still creating .csv if 3rd step error out.

  Sequence Container ==> Transaction ==> Transaction Option is REQUIRED

  Step 2 Data Flow ==> Transaction ==> Transaction Option is REQUIRED

  Step 3 Data Flow ==> Transaction ==> Transaction Option is REQUIRED

  Note: - The workaround would be event handler if Step 3 failed execute "Delete file", But I want to know other solution if there is any.

  any advice?

  Thank You.