Viewing 15 posts - 2,896 through 2,910 (of 14,953 total)
Restricted Session and Single-User aren't the same thing. Single-User just blocks anyone else from using the database at the same time. Doesn't restrict the number of transactions, et...
November 9, 2011 at 6:43 am
L' Eomot Inversé (11/9/2011)
Koen Verbeeck (11/8/2011)
L' Eomot Inversé (11/8/2011)
November 9, 2011 at 6:35 am
GilaMonster (11/8/2011)
How can BCNF be sensibly discussed if the earlier normal forms aren't known?
Same way you can teach Algebra without learning Arithmetic first. You just ... uh ... well...
November 9, 2011 at 6:24 am
Steve Jones - SSC Editor (11/8/2011)
November 9, 2011 at 6:22 am
It's iterating through weeks. 7 doesn't indicate June (not sure why it would, but it's commented that way), it's a multiple of a number of days based on the...
November 9, 2011 at 6:18 am
L' Eomot Inversé (11/8/2011)
Roy Ernest (11/8/2011)
I am planning on a presentation for my user group "DBA MythBusters" (Courtesy Paul Randal)...
November 8, 2011 at 2:26 pm
jshahan (11/8/2011)
November 8, 2011 at 2:20 pm
Finding overlap is easy.
If the AvailableTo is later than the AppointmentStart, and the AvailableFrom is earlier than the AppointmentEnd, then they have an overlap. That's a simple join condition.
What...
November 8, 2011 at 2:08 pm
SQL Kiwi (11/8/2011)
PaulB-TheOneAndOnly (11/8/2011)
Not in the sense of over-booking partial flight legs like this system does
Fair enough. Booking part of a flight is an intriguing idea though - parachutes...
November 8, 2011 at 1:59 pm
If you can use them, Table Valued Parameters (TVPs) are a new feature in SQL 2008 which do this very, very well. It's basically what Dixie Flatline suggested, but...
November 8, 2011 at 1:33 pm
I usually go to properties of the connection, click on the "..." button next to Expressions, select Connection String from the drop-down, build the expression.
I'm assuming you've tried that already,...
November 8, 2011 at 1:30 pm
I checked, and the connection string for xlsm files needs to be "Excel 12.0 Macro". Try that.
November 8, 2011 at 12:50 pm
Have you made sure you have that connection driver installed?
November 8, 2011 at 12:48 pm
Try this format for the connection string:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\SSIS\TXQuoteActivity\TXQuoteActivity.xlsm;Extended Properties="Excel 12.0 Xml;HDR=YES";
(You have the file extension as "xlsm". I'm used to "xlsx". Is that a typo, or is the...
November 8, 2011 at 12:44 pm
Is the connection string blank/incomplete at validation-time, and populated by a variable at runtime?
If so, have you set Delayed Validation on the package?
November 8, 2011 at 11:37 am
Viewing 15 posts - 2,896 through 2,910 (of 14,953 total)