I need to replace ',' with '|' in some specific position in each row in fixed width file using SSIS VB script task.

  • Thread starter Thread starter Sanjusamson
  • Start date Start date
S

Sanjusamson

Guest
I have a fixed width file, where I need to replace ',' with '|' in some specific position (Pos column 100 to column 200) in each row except Header and Tailor rows in fixed width file using SSIS VB script task.
I dont want to use derived column but only VB script task. Could anyone please share the script?

Thanks in advance.

Continue reading...
 

Similar threads

S
Remove first character from each line of a fixed width file using SSIS VB.Net script task.
Replies
0
Views
86
Sanjusamson
S
S
I need to change the extension of all the files in folder where extention is '.TXT' to '.DAT' using SSIS VB script task.
Replies
0
Views
130
Sanjusamson
S
K
SSIS PACKAGE - Script Task
Replies
0
Views
220
Khan345
K
K
SSIS PACKAGE - SCRIPT TASK to Convert txt to XLS
Replies
0
Views
106
Khan345
K
M
Output SQL Table to existing Excel file in SSIS / C#
Replies
0
Views
86
MChalut
M
Back
Top