Remove and Add Header and Footer using SSIS for Reading and Writing

359 Views Asked by At
CREATE TABLE Items
(
Product varchar(10),
Customer varchar(10),
Store varchar(10)
)

Question 1: I have to use SSIS and generate a file items.txt in the below format from the above table. The first line is a hardcode value "Header|Items" and the trailer is Trailer|Recordcount:" + records count.

Question 2: I have to use SSIS to read the items.txt file in the below format and load only detail records to the above Items table.

Line 1 : Header|Items

Line 2 : ProductData1|CustomerData1|StoreData1

Line 3 : ProductData2|CustomerData2|StoreData2

Line 4 : Trailer|Recordcount:2

I have to use the same file format mentioned in the above example no alteration of file format is allowed.

0

There are 0 best solutions below