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
#1086758
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
#1083113
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
#1081662
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
#1072648
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
#1061257
Could this apply?
http://support.microsoft.com/kb/933835
October 2, 2009 at 11:36 am
#1061095