You could place the file location information in a xml file or a sql table, using a package configuration to retrieve the information into a variable. You could then...

You are asking the right questions and I think the other posts provide needed insight to the possible options given your particular circumstances. If you are not sure about...

I think Steve has it scoped pretty accurately.  His last sentence is profound because it is very true and applies clearly to what can be a very emotionally charged topic.

Like most in our field, I have had times in my career where I have had extended periods of working 60-70 work weeks (Y2k was the most painful), but those...

He originally mentioned that the server was being used for ETL also.  The O/S memory over and above the 4 gig SQL uses can be used by the ETL tool,...

Turns out I was not giving the execution account with sufficient privileges...even though I thought I was.

Thanks!

I work as the only person who functions in a dba role for a mid-sized company (300 mill. annual sales) with 30+ servers that have MS SQL 200 or 2005 on...

Thanks to all who have responded!  All of this information is helpful.

Bob McEuen

Thanks!  Obviously we will test before we trust, but I wanted to see if there were any absolutes before we go through the exercise.

While I agree with your point, I am not sure I agree that the reason is as simple as someone not willing to fail, which I think is really just...

Check this link out... http://www.sqlis.com/

You will find a 'File Watcher Task' that you can download and add to your SSIS toolbox that will make this task relatively simple.  You...

Mark, glad you have it worked out!

I have read about a number of people having the 'it is slower than it was' problems after upgrading so I know you aren't...

I know this is going down a different track than others are taking you and I am not as skilled at performance tuning as others who have responded; but it...

I am currently testing the implementation of partitioned tables also.

In addition to the resources mentioned, I have found the information from the 'Project Real' test that MS did in conjunction with Barnes...

Please consider limiting your editorials to those that cannot EVEN be mistaken for political statements. 

I suscribe to your e-mails to learn about technology.  I don't care about your political views, whether...