Viewing 15 posts - 9,151 through 9,165 (of 11,678 total)
This is a data mining forum. Please post your question in an SSRS forum, where you'll probably get faster and more accurate results.
July 25, 2011 at 4:11 am
kapfundestanley (7/15/2011)
Anyone who knows who contributed the question and answers?
Probably the guy/girl who started this thread?
July 15, 2011 at 6:26 am
You can use OLE DB sources to connect to both sources and fetch the data. Make sure you use ORDER BY queries and mark the join columns as sorted in...
July 15, 2011 at 5:49 am
GBeezy (7/15/2011)
Thanks everyone for the help....I choose the Database Developer path. This could end up being a BI Developer or could lead back to a DBA type path.
Well, good...
July 15, 2011 at 5:44 am
rakesh.sharma1981 (7/15/2011)
Thanks for the reply however I am looking if SSIS Packages can provide something like that.Thanks & Regards,
Rakesh
Out of the box? No.
July 15, 2011 at 4:42 am
cengland0 (7/15/2011)
July 15, 2011 at 3:26 am
Sriram.RM (7/15/2011)
I would certainly try to avoid the RBAR. It is notoriously slow. As long as your dataset isn't that big that it chokes the tempdb with the temp table,...
July 15, 2011 at 3:25 am
Sriram.RM (7/15/2011)
July 15, 2011 at 3:18 am
This is going to create an outrage! 😀
(on that on a Friday)
Steve will correct this and award points back, no worries.
July 15, 2011 at 2:19 am
Read this blog post for more background information on your problem:
July 15, 2011 at 1:36 am
Craig Farrell (7/15/2011)
Koen Verbeeck (7/14/2011)
Isn't this on the right track?http://www.microsoft.com/learning/en/us/course.aspx?id=2778A
It doesn't cover everything (such as reading a query plan), but it covers most of the basics...
Hm, right idea, but certainly...
July 15, 2011 at 1:09 am
You'll need to put some ETL into place that cleans up the data before you load the cube. SSAS expects clean data, so you need to solve this issue before...
July 15, 2011 at 1:05 am
The SQL Server Native Client 10.0 (the default if I'm not mistaken) should have no problems connecting to SQL 2005.
July 15, 2011 at 1:02 am
Phil Parkin (7/15/2011)
:blush: I forgot there was one.
Because it is Friday, I will forgive this one 😀 😎
July 15, 2011 at 12:50 am
Please do not crosspost. It wastes peoples time and shatters replies.
Original thread can be found here:
http://www.sqlservercentral.com/Forums/Topic1142130-1633-1.aspx
July 15, 2011 at 12:47 am
Viewing 15 posts - 9,151 through 9,165 (of 11,678 total)