Viewing 15 posts - 61 through 75 (of 130 total)
Phil Parkin (3/13/2011)
March 14, 2011 at 8:46 am
I tried the following and worked, no problems on 2008, and cant see why it wount work on 2005 as well.
UPDATE T1
SET [successor_functionid] = NULL
FROM [dbo].[function] T1
INNER JOIN [dbo].[function]...
March 14, 2011 at 8:27 am
kendoln (3/11/2011)
March 14, 2011 at 7:12 am
LexusR (3/3/2011)
try without ssisbulk insert into FlatBuffer ...
and parsing into tables
In one or two package I do the import into a table with ID column and one column of varchar(max)....
March 14, 2011 at 6:39 am
In case your tutor is teaching you that arrays are part of an RDBMS, I'd strongly recommend to skip that class...
LOL!
March 14, 2011 at 5:28 am
kent.kester
Instead, I got the most brutal, rapid-fire, questions about everything from the minor details of SQL Server's limits (max index size, max table name length, etc. - for 2000...
March 14, 2011 at 12:39 am
More startling than odd... Someone mentioned to me once that he likes to ask "How would you react if I told you that so far, your interview is terrible?"
I'm totally...
February 24, 2011 at 11:22 pm
ben-732740 (2/22/2011)
I would like to have an SSIS package which "watches" a table for a certain condition, and when the condition is met, produce a file.
Wel,, how often is this...
February 24, 2011 at 11:12 pm
Read-Only ? , how do you load the data into the warehouse if it's read-only?
Not Read-Only as in Read-Only, Read-Only as in Read-Only. 😀
Read-Only as in data will...
February 24, 2011 at 8:46 am
mark.marsh (2/24/2011)
I think the primary difference between a data warehouse and a Database is that the warehouse is a refreshable, read only image of 1 or more data sources data.
Very...
February 24, 2011 at 8:31 am
Well, well, well.
I thought it might be nice, but if that is direct from M$ then it can be done.
Next time Im importing a Excel book, I'm going to give...
February 24, 2011 at 12:47 am
Koen, I'm thinking Jet, really not sure if you could, but previously have worked a lot with Excel & Excel VBA, and Named Ranged solved a lot of these types...
February 24, 2011 at 12:05 am
Just a thought, and I'm not sure that it will work, but what about importing "Named Ranges" from the Excel sheet, will sort out the problem if you could import...
February 23, 2011 at 11:40 pm
Personally, I've got 40 daily package using a file for each configuration. About 38 of them uses just the 1 config file, and then the others have an extra config...
February 23, 2011 at 11:38 pm
I would add, just because you have fact and dim tables does not make it a data warehouse. I've worked on warehouse before and the definition there is that it...
February 23, 2011 at 11:05 pm
Viewing 15 posts - 61 through 75 (of 130 total)