I have Flat Source File having multiple records type.I want to split data into different flat Destinastion files.
Each row have specific value to identifed the Destination File Name.But the number of files are two large and dynamically are entered new ones. So i can not hard code the destination files.
Here is the in the diagram
Flat File Source ---------------->ScriptComponent--------------->Dynamic File Destination
I created a User defined variable uses component script which sets the dynamic file connection string but i execute the SSIS it does not take the value from the variable and store in the file location with the real name.
Here is the code:
Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
Dim var As IDTSVariables90
var("User::CurrenFile").Value = Row.substring(198,2)
and here is the expression which it should be update for each row.It Updated the variable but it not uses in the expression.
ConnectionString = "c:\\test\\region_" + Row.Region + ".txt"
IT JUST COPIED DATA INTO FILE NAME c:\test\region_.txt
If Any one can help me i am very thanks for him.