Viewing 15 posts - 8,776 through 8,790 (of 9,720 total)
I'm still not getting this to work. Does anyone have any thoughts on how to select from an XML column in a table and shred it to a relational...
June 23, 2008 at 10:11 am
Subquery then.
Select *
from OrigDs
where ID in (Select Distinct ID from NewDs
where MyNewCol...
June 23, 2008 at 10:05 am
Do you have the ability to do a T-SQL join back to your original record source?
If so, then do "Select * from OrigDs od join NewDs nd on od.ID =...
June 23, 2008 at 8:14 am
David,
I'm confused. When you say you added an extra column, where did you add it? To the Source before you pulled the data or are you pulling the...
June 23, 2008 at 8:00 am
David,
If you've added that extra column, there's no need to use the IN() clause. You can just do the variables as I stated previously and use a "WHERE MyNewCol...
June 23, 2008 at 7:02 am
MERGE JOIN is something I'll look into. The one time I played with it, I couldn't quite figure it out. I can't remember exactly what my problem was...
June 23, 2008 at 5:56 am
Michael,
Actually, the SSIS package I'm building is pretty huge already and the last few times I tried to use LOOKUP, my performance ended up being worse than using a stored...
June 23, 2008 at 5:43 am
When you say your IDs aren't sequentially, what exactly do you mean? Could you give us a RL example of several IDs so we can see?
You could use a...
June 23, 2008 at 5:35 am
Sebastian,
Enable logging on the package to see where your problem might be. Also, consider running Profiler while running the package.
Lastly, have you tuned your initial queries? It might speed...
June 18, 2008 at 12:30 pm
Open up Integration Services in SSMS to Server A. Right click package in question. Click "RUN PACKAGE" and do NOT panic... @=)
Window will pop up. Pick all...
June 18, 2008 at 12:21 pm
Hmm. I was going to recommend using the Row_Number() function to build your original query, then realized your post sounds like you're not pulling your source records from SQL...
June 18, 2008 at 12:18 pm
Peter,
I'm trying to avoid setting a variable if I can. I want to read directly from the table that I've got set up. I'm going to have a...
June 18, 2008 at 7:21 am
Darnit. Still coming up with NULL as my result. The XML column has data like below (though there are more elements than I've listed):
<row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<AgentID>11</AgentID>
<AgentName>Luke...
June 17, 2008 at 6:41 am
Ahha! I was taking the CAST part of the referenced article too literally. I found a different article on MS's site that references the type of query I'm...
June 17, 2008 at 5:36 am
Hmm. Interesting article. I'm going to have to play with it, though, because it looks like it won't allow me to select the column from the table directly.
Thanks for...
June 16, 2008 at 12:41 pm
Viewing 15 posts - 8,776 through 8,790 (of 9,720 total)