CODEWITHSUNDEEP
ssis
user3019904
user3019904

Reputation: 21

How to append row count to the file name using ssis?

I have created a variable called RowCount, used rowcount transformation to store the number of rows retrieved from the source and I am trying to append the row count to the flat file name. But the variable is not saving the rowcount, it always returns 0 my filename is xyz_0 which is not I am looking for. Could some one please help me figuring out the solution for this ?

Upvotes: 0

Views: 1191

Answers (1)

Pintu Kawar
Pintu Kawar

Reputation: 2156

You can not append the row count value with the filename within the data flow task, as your dynamic flat file connection manager is getting populated before executing the Data Flow Task.

To fix it, use script task or File System task in control flow after the data flow task to rename with row count appended.

Upvotes: 2

Related Questions