June 22, 2009 at 9:45 am
All I am trying to do is copy a file to a different folder in a script task.
Package 1 - I already have a package that reads an input file in a script component and loads the data into a table. I added a script task so that the same file can be copied to a different location. When I run in debug mode the script task shows green but the file is not copied. I tried setting breakpoint to see what is happening, what is strange is another SSIS window opens and I Haven't been able to step through the code.
Package 2 - What is really strange is, I have another package that reads a flat file using script task and writes some data to another file, then loads the data into a table and at the very end has a script task to copy the input file to a different location.
If I change the input file name and location on the package 2 to the location and file name from package 1, the file gets copied. If I copy the code from the package 1 and paste it into the code on the package 2 now mysteriously the package runs the script task but the file never gets copied.
Is there any one aware of situations where the script task shows that it ran fine but never executes the code. If so can you please let me know what needs to be done to make sure the code does get executed.
Thanks,
Peter Kennedy
June 22, 2009 at 4:34 pm
June 22, 2009 at 5:55 pm
Have you tried putting a msgbox in the code to verify 100% that it is not running?
You could also check that the EntryPoint property for your script matches the class name in the script (it's ScriptMain by default).
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply