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...

Bru Medishetty (11/3/2009)

---

Then If I am in your position, I would create a Cursor that iterates through all the Tables in that Database and run this Command,

DENY UPDATE...

kkapferer (11/3/2009)

---

Bru,

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...

By the way, here's a good read on the subject:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/

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...

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...

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...

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...

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...

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,...

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. ...

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...

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...

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...

Yep, SQLGuru is absolutely correct.