Viewing 15 posts - 1,306 through 1,320 (of 3,232 total)
Depending on how big your table is, you may want to consider re-building it by moving the 'good' data over into a new table instead of stripping out the bad...
July 22, 2009 at 10:01 am
Jeremy Giaco (7/22/2009)
John Rowan (7/21/2009)
I'm in agreeance with the others. Why do you think you need a temporary table for SSIS?
There are a lot of situations....We had a ton...
July 22, 2009 at 9:51 am
Ah, my bad. I didn't see that you wanted just the top 10 for each one. I was thinking you wanted to generate 10 rows for each row....
July 21, 2009 at 3:20 pm
Jeffrey Williams (7/21/2009)
John Rowan (7/21/2009)
July 21, 2009 at 2:51 pm
Your data flow looks fine to me. Are you sure that the failure is not because the Type value that the lookup is searching for does not exist? ...
July 21, 2009 at 2:31 pm
Guys, 2147483647 is not 2 TB. The default value for Max Server Memory(MB) is 2147483647, which is 2 GB. I know, I know the counter should be MB,...
July 21, 2009 at 2:09 pm
I'm in agreeance with the others. Why do you think you need a temporary table for SSIS?
July 21, 2009 at 1:03 pm
What is the structure of the table that you need to populate? What do you need in the table, just the DOCID and a Sequence (1-10) number?
By...
July 21, 2009 at 12:57 pm
Your SQL Server is only set up to use 2 GB so I'm sure it is not using 95-98%. Check the Total/Target SQL Server Memory counters to verify the...
July 21, 2009 at 12:55 pm
COALESCE searches through the list of values and returns the first non NULL value. So, SELECT COALESCE(NULL,NULL,NULL,1) would return 1. In the code I posted, when both columns...
July 21, 2009 at 10:18 am
NULLs represent unknown values. So NULL is not equal to NULL because both values are unknown - how can they be equal. You need logic in your compare...
July 21, 2009 at 10:00 am
Use a Lookup transformation in your data flow. Use the values in the file to lookup the FK value in your second table.
July 20, 2009 at 5:00 pm
The code is not working in the proper way.
What is it doing, are you getting an error? It would help if you could post your code, sample data, and...
July 16, 2009 at 12:23 pm
If you'd like help improving the performance of this update, post your table DDL and the Cursor SELECT. This looks like it can be done in a single update...
July 16, 2009 at 10:42 am
First, I'll give you the blanket warning that storing dates as varchars is just plain bad practice. I'm sure, just like anyone else, you're working with a design that...
July 16, 2009 at 9:49 am
Viewing 15 posts - 1,306 through 1,320 (of 3,232 total)