Viewing 15 posts - 6,541 through 6,555 (of 9,715 total)
One thing that may help (in the long run) is to come up with a DOs and DON'Ts list (Database standards). If you're cleaning up the code, you know the...
February 9, 2011 at 7:34 am
I advise using SSIS. You can set up filenames using expressions in SSIS and make it repeatable.
February 9, 2011 at 7:30 am
Ninja's_RGR'us (2/9/2011)
Do you have by any chance a copy of the script you use the create or load the table? In that...
February 9, 2011 at 7:27 am
So do you have any alternatives to his thoughts on how he has to process his updates / inserts? Or does he have the order correct?
February 9, 2011 at 7:19 am
GilaMonster (2/8/2011)
Jeff Moden (2/8/2011)
Brandie Tarvin (2/8/2011)
proper American EnglishAccording to some of my British friends, that's an oxymoron. 😛
Absolutely. 😀
To prove my professionalism, I shall respond to your comments in...
February 9, 2011 at 7:17 am
Given the form of your question, I assume you're looking for a tool?
Try SSIS. It has an FTP task within the tool (which is why there's some confusion) and it...
February 9, 2011 at 7:13 am
To further explain what Mike was saying:
In computing, NULL means unknown. Not nothing. Not zero. It means "I don't know the value of this variable/object." Since the value is not...
February 9, 2011 at 7:02 am
It's in the connections manager property of your package. SSIS packages create and drop multiple connections when running, which kills your temp table before you've had a chance to use...
February 9, 2011 at 6:56 am
I'm glad you found the solution and thank you for posting it. It will help others.
February 9, 2011 at 5:12 am
GilaMonster (2/8/2011)
Craig Farrell (2/8/2011)
LOL! True enough, Saint Gail, Patron Saint of the "Oh Crap, my drives just died!"LoL.
On that topic, who's joining me tomorrow night? http://www.quest.com/backstage/pow.aspx
Oh, that looks...
February 9, 2011 at 4:46 am
I have, on several occasions, asked stupid or trick questions of potential co-workers during the interview process. I want to see how they react, how seriously they take the question,...
February 9, 2011 at 4:41 am
Hey 2k8 T-SQL experts, need a little bit of advice on this topic: http://www.sqlservercentral.com/Forums/Topic1059305-391-1.aspx?Update=1. It's a follow up to a schema design question.
I know there's a fancy T-SQL construct for...
February 9, 2011 at 4:28 am
It would be something like that. But I believe SQL 2K8 has access to more advanced query language (I'm still on 2k5) that would allow you to Insert and Update...
February 9, 2011 at 4:24 am
Viewing 15 posts - 6,541 through 6,555 (of 9,715 total)