Viewing 15 posts - 6,541 through 6,555 (of 9,720 total)
Nevermind! It's my bad.
I failed to notice that the ClientIDs are different as well as the ClientNumbers and that some of those IDs are filtered out of the Fact table...
February 9, 2011 at 8:05 am
It looks like you've posted your question in the wrong forum. This forum is for backup related issues and your query doesn't look like it's saving backups or doing restores.
I'm...
February 9, 2011 at 7:57 am
Oh, this sounds like a Question of the Day scenario. One of you should totally send this in.
February 9, 2011 at 7:40 am
Post the query you're using and we'll see what we can see.
February 9, 2011 at 7:38 am
I forgot to ask. What is the exact text of the error you're getting?
February 9, 2011 at 7:35 am
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
Viewing 15 posts - 6,541 through 6,555 (of 9,720 total)