The file watcher would work or you can use the foreach task. You can set the foreach task to look for a pattern (somefile_*.txt). If it finds something...

Have you specified an smtp server? I don't know if there is a way to change it using the GUI, but I know that there is a .config xml...

I would suggest looking at the logs on the server you're backing up to and also determine if there were any network issues at that time. Also, were there...

Can you clarify you question? Are you asking if you can backup to a network share?

This may work for the time being. Thanks for the suggestion. After reading some of the parameters of bcp it doesn't appear to support headers. Is there...

It appears after reading several different blogs that you cannot modify the metadata at runtime. Anyone have other suggestions?

Does the job fail or does it go into suspend status? We had an issue the other day in our test environment where we could not schedule SSIS jobs...

Are you able to backup the database locally? In my company's environment, we do a full backup of our datawarehouse to a network drive and it's around 260GB.

Are...

Thanks for the feedback.  This was my first article and by no means am I an author.  The article name is a bit misleading.  I didn't realize it until it...

I turned on the output file in the job and it gave me what I needed to see.  Turns out I needed to use a different method for defining that...

Here's something interesting (at least for me), when I changed the date from 01/01/04 to 02/04/04, the execution plan shows the index being used.

Thanks Steve.  Doesn't that defeat the purpose of having an index?  The results may be a large number of rows, is there a way around this?

J.D.

of course. I should have caught that. Thanks for your help.

Thomas,

Thanks for your prompt response. I took your query and filled it in with my tables, but it is erroring out.

 Select TheLatest.project_code, Previous.launch_date_before...