Viewing 15 posts - 3,046 through 3,060 (of 9,703 total)
TheSQLGuru (11/12/2014)
November 13, 2014 at 5:27 am
I still need to re-read this article a few times to make sure I understand everything, but I do have one question after the first read through. When combining FCI...
November 12, 2014 at 10:12 am
Thank you for the link, Grant. There are indeed a lot of variables in this proc. So it sounds like you've hit the nail on the head.
I'll take a look...
November 12, 2014 at 6:43 am
patrickmcginnis59 10839 (11/11/2014)
Brandie Tarvin (11/11/2014)
November 11, 2014 at 8:34 am
To clear up a misconception... we did stop the processes on the Test machine and I was immediately able to connect, as was the DBA sitting next to me. Plus...
November 11, 2014 at 5:54 am
You have two different date formats in your sample code. Unless you have a way for SQL to auto-identify which log strings contain which date formats, you're going to continually...
November 10, 2014 at 12:06 pm
Koen Verbeeck (11/7/2014)
Brandie Tarvin (11/7/2014)
November 7, 2014 at 7:05 am
Koen Verbeeck (11/7/2014)
Ah, so not a permission issue after all 😀
I knew it wasn't. I just couldn't figure out how to create the correct connection manager. Now I'm kicking myself...
November 7, 2014 at 7:02 am
Brandie Tarvin (11/7/2014)
Koen Verbeeck (11/7/2014)
Is the package stored on the machine itself, or on a UNC path?
The package is stored on the machine itself under D:\SQLServer\MSSQL10\100\DTS\Packages\My Folder\. In Integration Services...
November 7, 2014 at 6:39 am
Koen Verbeeck (11/7/2014)
Does it already fail in BIDS?
Yes. In fact, I haven't gotten past BIDS to running it from the GUI or a job. What I'm doing is running the...
November 7, 2014 at 6:35 am
Can someone please help me here? I am having a very bad week, so I'm about to lose my temper with Stewart because he wants to focus on security issues...
November 7, 2014 at 6:08 am
Stewart, I have been a DBA for over 10 years. Please give me a little credit for knowing the basics.
Can we please get to the question I am asking?
EDIT: And...
November 7, 2014 at 6:00 am
I am not asking a question about permissions. I am asking about how to set up the connection manager.
November 7, 2014 at 5:36 am
The odd thing is that I've gotten this response when researching BIDS / Visual Studio errors too. This was last week and I don't recall anything that had variable names...
October 17, 2014 at 12:26 pm
Gary Varga (10/16/2014)
IMHO (10/16/2014)
In answer to the question Who Watches the Watchers...robots....CCTV???
Max Headroom.
October 16, 2014 at 8:48 am
Viewing 15 posts - 3,046 through 3,060 (of 9,703 total)