Execute Process Task -
File details
Column Name1, Column Name 2..
1, 2
F000000001
Script Psuedo code
- Read the no of lines in the csv file and store it in a variable
- Store Footer information in a csv file exg Variable A - 1
- compare the number of lines variable with Footer variable
- if match found - Truncate the footer and create a copy of the file
instead of writing the bat script.is this can be done by creating the package in SSIS,