Viewing 15 posts - 7,846 through 7,860 (of 13,876 total)
hazeleyre_23 (12/10/2015)
How do I get the date to change if the time someone works goes past midnight.
i.e if someone works 21:00 - 06:00.
I have a roster date column, start shift...
December 10, 2015 at 6:05 am
Also, note that SSIS is not really suitable for 'run-time prompting' as it is intended to run unattended on a server.
December 9, 2015 at 8:22 am
Another thumbs up for SQL Prompt Pro from me.
SSMS Boost has some features which I also use frequently:
1) Connection shortcuts. Define connections to different databases on different servers and from...
December 6, 2015 at 2:49 pm
ramadesai108 (12/4/2015)
I have resolved the issue.
It may be of interest to other forum members to know how you solved your problem. I'm guessing you did something like
With (your original query)...
December 4, 2015 at 3:15 pm
If you know that ; is a terminator and then deliberately use it as an initiator, it is an indication that you are not interested in getting the little details...
December 2, 2015 at 9:51 am
martin 22999 (12/1/2015)
Well its nice that you expect it to run, but it doesn't 🙁So what am I doing wrong, and what should I do?
Leave the package exactly as is,...
December 1, 2015 at 5:54 pm
It's not a scenario I've had to deal with. However, I would have expected it to run just fine, assuming you have the connection string to the new server properly...
December 1, 2015 at 2:05 am
BrainDonor (11/27/2015)
Phil Parkin (11/27/2015)
They're using Informix.
Hence the word 'Informix' in the error message. Obvious now, thanks.
If my message sounded sarcastic, I apologise. That was not my intention.
November 27, 2015 at 5:04 am
BrainDonor (11/27/2015)
Could somebody have a look at http://www.sqlservercentral.com/Forums/Topic1740538-391-1.aspx#bm1740579 please?
Either the driver they're using doesn't allow some the solution I'm suggesting, or...
November 27, 2015 at 4:09 am
So satisfying when you can improve things like that, well done.
November 26, 2015 at 9:19 am
Re1 (11/26/2015)
The source query is taking very much time to produce the data.
below is a sample query used in source component.
tbl_documents table is having 700 rows and tbl_documentdetails...
November 26, 2015 at 7:25 am
John Mitchell-245523 (11/26/2015)
November 26, 2015 at 4:14 am
gkramer 23701 (11/26/2015)
I cannot restore it with the same name on the same databaseserver and I'n not able to restore it to another server (not even with the initial name)!!Guus
Hehe,...
November 26, 2015 at 3:42 am
November 26, 2015 at 2:23 am
TomThomson (11/25/2015)
Steve Jones - SSC Editor (11/25/2015)
Alvin Ramard (11/25/2015)
Steve Jones - SSC Editor (11/25/2015)
November 26, 2015 at 12:41 am
Viewing 15 posts - 7,846 through 7,860 (of 13,876 total)