Viewing 15 posts - 5,746 through 5,760 (of 9,722 total)
If I got questions like that (phrased exactly like that), I would have to refer them to Books Online and the multitude of SQL Server books saying "I can't explain...
June 16, 2011 at 10:14 am
Another is to do an INNER JOIN to a subquery for the CustID and MAX(EndDate), joined on both fields.
A third method would be to put the above subquery into a...
June 16, 2011 at 10:11 am
Can you post some pictures?
I'm looking for the following images:
Control Flow
Package level properties (all)
Container level properties (all)
Outside task level properties (all)
We're having a communications disconnect and I think it...
June 16, 2011 at 9:58 am
quillis131 (6/16/2011)
one container and one task ( script ) outside the container. Check points are enabled on container and Script task. Am I clear???...let me know
Yes, that's clear. Thank you....
June 16, 2011 at 9:24 am
Phil Parkin (6/16/2011)
Ah indeed. OK, try this one (it's a big page, search for fuzzy and you'll find it towards the end of the page).
Ahha! There we go. Thanks for...
June 16, 2011 at 9:22 am
radb4u, My previous post is not saying Phil is wrong. Generally, these things don't change between editions. But I have yet to find the pudding to find the proof that...
June 16, 2011 at 9:20 am
Daniel Bowlin (6/16/2011)
Brandie Tarvin (6/16/2011)
Brandie Tarvin
PneumonoultramicroscopicsilicovolcanoconiosisSQLRNNR (6/15/2011)
Now what does it mean?It's a lung disease caused by silica.
But can you pronounce it?
Sure. Pneumonoultramicroscopicsilicovolcanoconiosis.
If you didn't hear me, it's because your...
June 16, 2011 at 9:11 am
Elliott Whitlow (6/16/2011)
To perform the moves of the files.. Did I miss something (entirely possible 🙂 )..
That's why I advised a combination of Execute SQL (to load the variables)...
June 16, 2011 at 9:07 am
Glad we could help.
Just remember, in SQL Server, there are redundant methods of accomplishing 1 task. So if you're stuck, ask for the alternatives.
June 16, 2011 at 9:06 am
Phil Parkin (6/16/2011)
Brandie Tarvin (6/16/2011)
Phil Parkin (6/15/2011)
You need SQL Server Enterprise Edition to use fuzzy lookup.
Phil, where did you get the idea that fuzzy lookup is only available to Enterprise...
June 16, 2011 at 9:02 am
sonal_anjaria (6/16/2011)
Could you elaborate a bit more about the input output wizard, i am quite new at ssis and under a tight deadline
In SSMS, open a connection to your Production...
June 16, 2011 at 8:21 am
If you have issues in the restore because of the lack of tail logs, let us know and we'll try and figure it out from there. But go ahead and...
June 16, 2011 at 8:18 am
GilaMonster (6/16/2011)
Brandie Tarvin (6/16/2011)
Try naming the Transaction. See if that gets around the error.Naming transactions does just about nothing. It's a documentation thing (with one minor exception)
I admit. That...
June 16, 2011 at 8:15 am
Elliott Whitlow (6/16/2011)
June 16, 2011 at 8:14 am
Elliott is correct on this one. Not only is SELECT...INTO going to cause you performance issues, but the use of * will also. Can I ask why you don't just...
June 16, 2011 at 8:13 am
Viewing 15 posts - 5,746 through 5,760 (of 9,722 total)