Viewing 15 posts - 931 through 945 (of 3,232 total)
There are some good suggestions here so far. If performance is your biggest concern, I'd suggest looking closely at SQL Server 2005 Table Partitioning. This will keep you...
November 3, 2009 at 2:28 pm
Bru Medishetty (11/3/2009)
DENY UPDATE...
November 3, 2009 at 2:26 pm
kkapferer (11/3/2009)
Thanks for the quick reply. This does not seem to help me. I feel like the reason for that is because this permission is not...
November 3, 2009 at 1:58 pm
By the way, here's a good read on the subject:
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/
November 2, 2009 at 2:54 pm
There are several ways to get values into variables within SSIS. You can populate variables with return values from SPs, full ADO datasets, Filenames from a for-each-file operation, expression...
November 2, 2009 at 2:49 pm
There's no real easy way to do this. One way, would be to build out an empty temp table based on the query and then query for the temp...
November 2, 2009 at 2:32 pm
The OPENQUERY statement allows you to execute SQL against a remote data source. In your case, the SELECT statement will be executed against the DBSER1 data source.
It...
November 2, 2009 at 2:29 pm
Lynn is right, more info would help. In the meantime, this may get you close to what you need:
SELECT t.SourceSiteID,
t.TreatmentDate,
t.Status
FROM myTable t
INNER JOIN (
SELECT SourceSiteID, MAX(TreatmentDate) as LastTreatmentDate
FROM myTable
GROUP...
November 2, 2009 at 1:43 pm
I could be totally wrong, but I don't think there is an uninstall for the service pack. You may be stuck with uninstalling the entire SQL instance, reinstalling the...
November 2, 2009 at 1:13 pm
Mark - Great use of the Tally table! Using a number table here makes this a quick/easy solution.
Mattie - just in case you need more info on Tally/Numbers tables,...
November 2, 2009 at 10:37 am
If you have to resort to this to prevent contention, I would recommend taking a serious look at the whole process that the stored procedure was introduced to do. ...
October 29, 2009 at 9:56 am
You may need to check all columns. If this is a fixed width file, the error may be misleading as a problem with the data for any column could...
October 28, 2009 at 4:09 pm
I would check your flat file connection manager and make sure your column widths are defined correct.
Any chance there's a character in your source data that is causing...
October 28, 2009 at 4:02 pm
Well, connecting from SSIS will be as easy as connecting from any other application. You first need a data provider. So if you can't find an OLE DB...
October 28, 2009 at 3:29 pm
Yep, SQLGuru is absolutely correct.
October 28, 2009 at 2:38 pm
Viewing 15 posts - 931 through 945 (of 3,232 total)