I am using foreeach loop and using data flow task to insert data into table. I got two columns FileName and Filepart both data type are
However I got a issue with data conversion.
Input Data = String
Column Name = FileName
I am using following expression for file part
REPLACE(SUBSTRING(@[User::FileName],1, FINDSTRING( ( @[User::FileName] ), "_", 3) -1), ".CSV", "")
ProductCatalog_180915_20100520 ------- Correct Format
ProductCatalog_180915_04062010 ------- Wrong Format
I understand FileName from foreeach is getting that info, but before I insert that data into temptable. I want all my data in this format.
Can anyone shed some light how to over come this issue.
Do I need to get data individually to each column (e.g. 04062010)
only and change it or else can I use derived column. If I get individually how to identify which one is this (e.g. 04062010)
and this (e.g. 20100520)
View Complete Post