Viewing 15 posts - 9,061 through 9,075 (of 11,678 total)
My connection string to SQL Server usually looks like this (using Windows authentication):
Data Source=myServer;Initial Catalog=myDatabase;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;
Try connecting to the server using the editor, and if that succeeds, look at...
August 8, 2011 at 6:09 am
If you create a stored procedure that inserts/updates data based on hospital and a year, that you can encapsulate that stored procedure into a transaction and just execute that stored...
August 8, 2011 at 6:05 am
You specify the provider in the SSIS package itself.
So you probably made an Excel connection manager, and there a connection string is created that specifies the JET provider.
Edit the SSIS...
August 8, 2011 at 4:33 am
From BOL:
The user must have permission to browse objects on the source server, and must have permission to drop and create objects on the destination server; moreover, the user must...
August 8, 2011 at 2:53 am
Great question to check if I'm still awake at Friday 😀
August 5, 2011 at 2:43 am
SQLkiwi (8/2/2011)
Good question, but try:
SELECT 'Test' WHERE EXISTS (SELECT LOG(0))
TSQL is not a model of consistency.
Nice question, and good remark Paul.
August 4, 2011 at 12:21 am
Daniel Bowlin (8/3/2011)
I really want this package to run these...
August 4, 2011 at 12:09 am
Fal (8/3/2011)
Koen Verbeeck (8/3/2011)
If you do try a Belgian beer once more, try one of the trappisten.
And make sure it is server as it should be server, it matters a...
August 4, 2011 at 12:08 am
Tom.Thomson (8/3/2011)
Koen Verbeeck (8/3/2011)
LutzM (8/3/2011)
Koen Verbeeck (8/3/2011)
Not only excellent chocolate, also excellent beers 😉
And I do need the diapers, just not for myself 🙂
(I just found out I can order...
August 3, 2011 at 7:43 am
It depends 🙂
Usually I don't eat alone, but sometimes when I have lots of work to do I eat alone.
Or when I have to surf the net or make some...
August 3, 2011 at 3:04 am
LutzM (8/3/2011)
Koen Verbeeck (8/3/2011)
Not only excellent chocolate, also excellent beers 😉
And I do need the diapers, just not for myself 🙂
(I just found out I can order diapers from the...
August 3, 2011 at 2:59 am
LutzM (8/2/2011)
I agree, for some stuff live is not really expensive over here. I'm not sure about cars though (less in Denmark or re-import from France, for instance). Or electronics...
August 3, 2011 at 1:11 am
LutzM (8/2/2011)
Oh, well ...
45EUR wired flat (phone flat wired to wired and wired to mobile, unlimited internet flat...
August 2, 2011 at 2:28 pm
Daniel Bowlin (8/2/2011)
August 2, 2011 at 2:20 pm
Viewing 15 posts - 9,061 through 9,075 (of 11,678 total)