So I have a variable named FileName in my SSIS package. The value is MyFileName.csv
(I need to preserve that value)
But I want to derive another variable which would contain MyFileName
I need a vbscript script to save the value, without the.csv, into another var name. And it needs to be in VBscript because I don't know C#.
Fairly easy to do, I'm sure. Thanks