I am using SSIS to transform my data. My file_name is test_heathcare.csv. How can I bring it to my flat file destination as new derived column being filename as test_healthcare20190712.txt?
If anyone know please help me .
Asked
Active
Viewed 98 times
2
-
Is the issue solved? – Yahfoufi Jul 17 '19 at 07:11
-
@Yahfoufi, Not yet . Still waiting for more response . – Kate Jul 17 '19 at 13:24
-
Have you tried the suggestion below? If you are looking to using derived column to change destination, it is impossible. The only way to use dynamic file path as destination is using expressions – Yahfoufi Jul 17 '19 at 13:56
1 Answers
1
You can use expressions to achieve that:
- Store your file path within a variable.
- Then click on the destination Flat File Connection Manager. Press F4 to show the properties tab.
- Go to Expressions property
From tge expressions window select the
ConnectionStringproperty and use a similar expression:REPLACE(@[User::FilePath],".csv","20190712.txt")
Additional Information
Hadi
- 36,233
- 13
- 65
- 124