Viewing 15 posts - 8,761 through 8,775 (of 9,720 total)
Hmm. That's a point I hadn't taken into consideration. I'm pretty new to all this DW / Cube stuff and am following the requirements laid out by the...
July 15, 2008 at 4:06 am
Actually re-assessing is what I'm in the middle of.
Problem is Datawarehouse design where I have to account for changing Entity records (different types of people where each "type" is in...
July 14, 2008 at 11:30 am
But if I misunderstood your question and you're just trying to run it on all DBs in Dev (for instance) and then later move it to test...
You have a couple...
July 14, 2008 at 11:14 am
First of all, you shouldn't be creating the stored procedure in all three environments at the same time. It violates the SDLC (Software Development Life Cycle) process and could...
July 14, 2008 at 11:07 am
Michael,
Your last post actually made sense. Until of course, I created another data flow task.
Of course, I can't be sure until I've finished running this step, but it appears...
July 10, 2008 at 11:23 am
I'd rather not have to add yet another SQL Login to my databases. And I don't want to give permissions to the current SQL Logins to this particular database....
July 3, 2008 at 8:08 am
Michael,
Does SQL Server support the parameter names consistantly?
Also, once I do this Update, I'm pretty much done with this data flow. I don't need to add a destination afterwards,...
July 3, 2008 at 6:39 am
Michael,
Actually, you can manually turn on the IsSorted property with the "Table or View" option. In fact, it's required in order to use a MERGE JOIN component right after...
July 2, 2008 at 10:50 am
Hmm. Interestingly enough, the solution seems to be to change the Source from "Table or View" to "SQL Command" and to use an actual SELECT statement with defined column...
July 1, 2008 at 8:43 am
I actually had my data flow designed in a top down, but I couldn't get it to all fit on one screen shot, so I moved everything left to right...
June 27, 2008 at 4:30 am
Well, my test Data Flow just completed. Even with 7 Sorts, 5 Merge Joins, 4 Conditional Splits and 2 Unions, it finished in 2 hours 32+ minutes, approximately 1/3...
June 25, 2008 at 7:52 am
Unfortunately, doing a separate staging DB is out of the question. We don't have the space for it. @=(
Interesting site. Have you used these components before? ...
June 25, 2008 at 5:27 am
My situation here is that I'm joining on no less than 6 tables to get my result set, with the final two tables being left outer joins that check for...
June 25, 2008 at 4:40 am
Michael,
It just occurred to me... Doesn't using a Merge Join mean you're pulling all columns of the table into SSIS prior to the task anyway?
I think that's why I originally...
June 23, 2008 at 12:07 pm
WHOOHOO!
That's the ticket, Matt! (Head cold or not, you is GENIUS). And I didn't even have to use the namespace declaration to make it work. The syntax...
June 23, 2008 at 10:36 am
Viewing 15 posts - 8,761 through 8,775 (of 9,720 total)