Viewing 15 posts - 31 through 45 (of 190 total)
Ah, well yes, I do. Unfortunately, each different data flow task represents a completely different export. So, if I were to also create a data flow for each file format,...
April 30, 2014 at 9:18 am
Well if I'm doing 4 different data flow tasks, then I could conditionally specify to only go to one of them, the other 3 wouldn't get executed, and the filename...
April 30, 2014 at 9:06 am
Yeah, I tried doing delayed validation, but it still tried to create the file. Unfortunately, the requirement is that the filename has to be the same. It can't change from...
April 30, 2014 at 8:57 am
Well, this is an OLTP-style database, but it's being used for reporting (a DW was not part of the project specification). Further, it is the recipient of replication from the...
February 14, 2014 at 3:30 pm
Thanks Gail. I know this may be a hard question to answer definitively, but in general for an issue like this, is it better design to use LEFT JOINs or...
February 14, 2014 at 1:03 pm
Yeah, I know, it's non-SARGable. That was really my last line of defense for shooting this idea down, because his next suggestion is to make that column non-nullable, and default...
February 14, 2014 at 12:38 pm
Unfortunately, this is a project still in the design phase, so it's not like we're trying to address an existing performance problem or anything. And, we only have about 100k...
February 14, 2014 at 12:35 pm
Yeah, putting them in their own filegroup was part of the plan. We don't really have anything fleshed out as far as the details of the transfer yet, as it's...
February 6, 2014 at 1:52 pm
Hi Steve,
thanks..we ended up restructuring our documentation so that we don't have to specifically address the idea of industry standards for data modeling. Oh well. 🙂
November 20, 2013 at 9:46 am
That's what I'm looking for. Thanks!
November 15, 2013 at 9:21 am
hahah...thanks for the assist.
October 22, 2013 at 2:56 pm
Hmm. Oddly, the publisher is set to 2005 compatability mode. Weird. I didn't create this database, so I"ll have to check with the DA to see if he was trying...
October 22, 2013 at 2:50 pm
10.50.1617 - single instance
10.50.1600 - cluster
I'm updating the cluster right now with the hotfix just to make sure that isn't the problem, though I have a hard time believing that...
October 22, 2013 at 2:43 pm
Yeah, which is why I said "weird error" not just "error" 🙂 No 2005 anywhere.
October 22, 2013 at 2:26 pm
Viewing 15 posts - 31 through 45 (of 190 total)