Viewing 15 posts - 11,506 through 11,520 (of 13,857 total)
YSLGuru (3/15/2011)
Phil Parkin (2/15/2011)
IMO this might be simpler if implemented in a Script Task.
For one with SSIS knowledge/experience this probably is easier to do in SSIS. However if you...
March 16, 2011 at 1:55 am
darth_vodka (3/15/2011)
as a work around, you can write a script task to copy over a blank spreadsheet to your connecting spreadsheet every time instead of clearing it down...
I second this...
March 15, 2011 at 8:22 am
quillis131 (3/15/2011)
March 15, 2011 at 8:20 am
That's true, I guess i would consider that to be a custom component, rather that a re-usable component.
A nuance I had missed - I agree with you.
March 15, 2011 at 6:12 am
steveb. (3/15/2011)
Sorry, It can't really be done in SSIS (Aside from cut+paste).
Not 100% true, though it's maybe not as easy as you would like.
Check out this link on building...
March 15, 2011 at 5:54 am
The design-time, or default, variable values in a package can be modified in code from another package.
Here's a script task which opens a package, looks to see whether it contains...
March 15, 2011 at 2:23 am
Yeah, I saw you were new so I went easy on you;-)
By the way, OP = 'original poster' and 'Adam' sounds more like a 'he' than an 'it' to me:-D
March 14, 2011 at 2:03 pm
Valuable input, but this thread is > 3 years old, so I imagine that the OP has either solved the problem or given up by now 🙂
March 14, 2011 at 1:41 pm
Craig Farrell (3/14/2011)
My <headdesk> exactly! Well, I appreciate the attempt.
No problem. There is very limited documentation around to explain which variables are 'hidden' and which are not.
If you set...
March 14, 2011 at 9:51 am
Quote from Technet about IDTSVariables100:
This API supports the .NET Framework infrastructure and is not intended to be used directly from your code.
See here.
Also, the system variable you have accessed is...
March 14, 2011 at 8:55 am
Anjan Wahwar (3/13/2011)
The way you are writing the script will work fine with SSIS 2008, though in your case i would rather suggest to use Script Task. You...
March 13, 2011 at 7:02 am
While it seems that there is a perfectly good variable waiting for you to access ("System::TaskName") (which I can see in my Variables window), this seems not to be available...
March 13, 2011 at 4:27 am
qew420 (3/11/2011)
Before writing to the 2nd table, I need to check the records in the table-Aso if there are no records then EXIT else next step
thx
Create an integer...
March 11, 2011 at 5:30 am
Viewing 15 posts - 11,506 through 11,520 (of 13,857 total)