Viewing 15 posts - 11,521 through 11,535 (of 13,870 total)
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
Or just develop the solution in the technology you feel most at home with.
Hmm, risky recommendation. Not sure I could solve this one using my iPod 🙂
March 11, 2011 at 4:07 am
Looks like everything worked OK apart from Send Mail - and that failed only because of a missing addressee?
March 11, 2011 at 3:34 am
Viewing 15 posts - 11,521 through 11,535 (of 13,870 total)