C:\To_Schools\ServiceA\Īnd VariableMapping (Value) e.g. Ive currently got a for Each Loop with a For Each File Enumeratorĭirectory (Value) e.g. If I can get it working Im also wating to do another one to strip files that start with Copy Ofīut I still cant do anything because I dont now how to use my variables in the 4 each loop. I could really do with a step by step guide on this. So how do I use these 3 variables to do the first step? (Or Am I completely wrong)? REVERSE(SUBSTRING( REVERSE( ), 1, FINDSTRING( REVERSE( ), "\\", 1 ) -1 ) ) I have a ToSchoolsFileName which is a variable to bring back the file name I have a ToSchoolsSourcePath which is just the directory only. I have a ToSchoolsFullFilePath which is just a value with a pretend file name at the end What variables to I need to configure this? Ive dont lots with IS over the last few weeks and I still find it incredibly difficult to get my head round The code will come in very useful but its this section that Im stuck with. Nitesh Rai- Please mark the post as answered if it answers your question Note: The code is in C# and if you are using SSIS 2005 then you have to convert it into VB code. String destpath = filepath.Replace("_", "") ĭts.TaskResult = (int)ScriptResults.Success Success = .DTSExecResult.Success,įailure = .DTSExecResult.Failure Public partial class ScriptMain : .ScriptTask.VSTARTScriptObjectModelBase Then put a script task inside foreach loop and add varfilename as readonly variable and use following code: using System Save the filepath in a variable (varfilepath). Take a foreach loop and configure it to iterate through the folder and capture the complete filepath (fully qualified option in froeach loop editor).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |