Viewing 15 posts - 9,871 through 9,885 (of 13,876 total)
Where to begin troubleshooting?
Put both result sets in database tables and run some queries so that you can understand what the extra rows look like. Then, maybe, you can...
May 29, 2013 at 12:52 am
KoldCoffee (5/28/2013)
May 28, 2013 at 11:50 pm
KoldCoffee (5/28/2013)
May 28, 2013 at 10:20 pm
Shree-903371 (5/28/2013)
May 28, 2013 at 2:20 pm
The syntax for the derived column gets difficult to maintain doing it this way, as more lookups are added.
An alternative is to use a lookup table - either physical or...
May 28, 2013 at 3:04 am
Jeff Moden (5/27/2013)
Phil Parkin (5/27/2013)
Here's a link that should get you started.
The 'asynchronous' part here refers to the...
May 28, 2013 at 12:25 am
This looks like bread and butter for an asynchronous Script Component to me.
Here's a link that should get you started.
The 'asynchronous' part here refers to the fact that the number...
May 27, 2013 at 12:26 pm
As far as I know, single procs which can return different result sets are not supported until SSIS 2012, where you can use the WITH RESULT SETS hint when calling...
May 26, 2013 at 1:50 pm
You seem to create a temp table called #ID, then INSERT and SELECT from #EID, which is not defined. Have you missed out a section from your code?
Can you possibly...
May 26, 2013 at 1:46 pm
Tobar (5/24/2013)
OK. Now I am starting to wonder about the wiseness of opening this argument. 🙂
Nah, I'm looking forward to your next thread: "would Jesus have made a good database...
May 24, 2013 at 8:47 am
Bhaskar.Shetty (5/24/2013)
Please reread my post. Use a dictionary, if necessary, to help you understand its meaning. I did not call anyone silly. I said that the post made you look...
May 24, 2013 at 7:37 am
Sergiy (5/24/2013)
Phil Parkin (5/24/2013)
Where is that post?
The first post of this topic.
But saying that you "cannot call insert like that" is clearly wrong.
Not if "like that"...
May 24, 2013 at 7:31 am
Bhaskar.Shetty (5/24/2013)
Sergiy (5/24/2013)
Phil Parkin (5/24/2013)
Where is that post?
The first post of this topic.
But saying that you "cannot call insert like that" is clearly wrong.
Not if "like...
May 24, 2013 at 7:21 am
Sergiy (5/24/2013)
Phil Parkin (5/23/2013)
Bhaskar.Shetty (5/23/2013)
You cannot call insert like that, = operator works while you are updating any row or table.
Before making blanket statements like this, I find that...
May 24, 2013 at 6:20 am
Your statement:
You cannot call insert like that, = operator works while you are updating any row or table.
Is plainly wrong - I proved it in code. And now you are...
May 23, 2013 at 1:18 am
Viewing 15 posts - 9,871 through 9,885 (of 13,876 total)