Not really en expert on this subject, but this article may help you.

http://www.mssqltips.com/sqlservertip/1867/sql-server-integration-services-ssis-performance-best-practices/[/url]

Hope if I understand you. If the same user that logs into the application needs to login to reportserver you need double hop authentication. So your admin needs to setup...

I double checked the execute permissions on the SP's and some didn't have the right permissions.

The package now works fine with db_datareader and writer and the execute permissions on the...

Thanks for your reply. Yes this could be a metadata sync problem, but I already tried refreshing the SSIS metadata.

The problem occurs in the validation phase of the data flow...

Shawn Melton (2/6/2011)

---

My $.02...That is a lot of work...I have to tell you that majority of that should have been provided by the developer that wrote the application, or the...

Thanks for you reply and suggestion. It seems that rewriting the queries is the only way to work around this problem.

Some of our .NET applications using ad-hoc queries (via...

Please read the link I posted. A max query does in fact use an index seek if the column is a primary key or indexed.

The query I provided was just...

Yes the scope of the variables are limited to the job step unfortunately.

Think I will go for the user defined function trick unless somebody has a better idea of course.

No I don't think it's possible to change the MDF and LDF location when using Management Studio. There is a default location, but that's only used as default path for...

Michael Valentine Jones (1/26/2009)

---

When you restore a backup, all database files will be created at the same size the database was when you backed it up.

If you want to control...

We encounter the same problems and Tim's suggestion should provide a solution

However because we use database mirroring it's kind of a challenge for us to change the recovery model to...