Viewing 15 posts - 11,521 through 11,535 (of 13,876 total)
Perhaps you would be courteous enough to answer Lynn's question?
March 16, 2011 at 7:33 am
Jeff
FINDSTRING is a built-in SSIS function, see here.
March 16, 2011 at 6:17 am
Description
D-1,D2
D-2,D-U,T1
U-5,T2,K-5,T3
NULL
Is that real sample data? Or have you tidied it up to remove trailing commas, perhaps?
If it is real, you are going to get errors with your derived columns in...
March 16, 2011 at 6:14 am
KrishnaChaitanya (3/16/2011)
I have created a package which loops through a folder containing Excel inputs and loads in to the SQL server database. I have deployed the package in SQL server...
March 16, 2011 at 5:34 am
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
Viewing 15 posts - 11,521 through 11,535 (of 13,876 total)