CODEWITHSUNDEEP
sql-serverssis
P.K.
P.K.

Reputation: 1772

SSIS: how to add one row to data from flat file source's data

Suppose I have flat file source with data

Col1 | Col2
A    | 123
B    | 213

and I want to add one row with values (C, 1321). How can I do it QUICKLY?

I know I can create new file with this one row, load it to flat file source and use UNION for it. But I want to create in SIMPLY way:).... just like insert to flat file source's data?

Upvotes: 0

Views: 1459

Answers (1)

MiguelH
MiguelH

Reputation: 1425

Double click on the Flat file destination transformation in the Data Flow and untick "Overwrite data in the file" checkbox. This allows the textfile to be extended. Note: You might need to include a File System Task to delete this file at sometime otherwise this file will extend endlessly!

Upvotes: 3

Related Questions