Viewing 6 posts - 31 through 36 (of 36 total)
There are a few ZIP tasks out there - some free. Check out the SSIS Community Tasks and Components[/url] directory, I list them there.
December 2, 2009 at 2:11 pm
No, you can not access any other tasks' or components' from within a Script.
If you want to modify another task or component's properties, the best ways to do that are...
November 23, 2009 at 12:43 pm
You are going to kick yourself... change this:
StrModifyScript = Dts.Variables("User::MODIFYSCRIPT").ToString
to this:
StrModifyScript = Dts.Variables("User::MODIFYSCRIPT").Value.ToString
November 19, 2009 at 9:35 am
Is the data type you're writing to a DT_STR, and the data type in the flow a DT_STR of a different code page, or a DT_WSTR? If so:
DT_WSTRs are...
October 29, 2009 at 11:01 am
Ahh - mapped drives.
Don't do those. Drives get mapped when you log on to a system - and Agent jobs "run as" an account don't log on, so drives...
October 2, 2009 at 4:42 pm
Could this apply?
October 2, 2009 at 11:36 am
Viewing 6 posts - 31 through 36 (of 36 total)