Or they will tell us that we are going to get a lot more than we expected!!!!

sushila - I have to agree with your Murphy's Law theory. I did take a substantial cut in pay to move to the country (over 10%) but it was for...

Erik, I once had a Professor who told me that trying to know everything about programming or a programming language is impossible! The trick to being considered a good programmer...

Ella,

Take a look at this site - it has examples for working with files.

http://www.sqldts.com/default.aspx?292

Good Luck,

Darrell

Try this,

Change the "exec sp_OAMethod @objFile, 'ReadLine', @strLine out"

to exec @blnEndOfFile = sp_OAMethod @objFile, 'ReadLine', @strLine out

Then check the value of @blnEndOfFile

Hope this helps,

Darrell

You betcha!!!!!

Now I have had the pleasure of listening to my older sons go from complaining about the smell of cow manure...

Personally, I prefer to wait for the offer before discussing salary.

I would think that the person searching for (or considering) a new job is intelligent enough to look at the...

Check to make sure that the logged user has execute permissions on the sp_OACreate objects in the master database (there are a couple of other sp that start with the...

Jones,

Here is a link that will show you how to skip individual steps/tasks in a DTS package.

http://www.sqldts.com/default.aspx?214

Good Luck,

Darrell

Vitor,

Take a look at this site and see if it answers you questions.

http://www.sqldts.com/default.aspx?279

Good Luck,

Darrell

Unfortunately the only way I know of would be to do a readline, increment counter and then one more loop through using your example of "write it to another file...

Mike,

I am not sure how much input the line workers actually have. I have a freind who is a line manager for GM that has the job of "random" sampling...

It is Monday morning and my brain isn't functioning fully yet so be warned!

You could use the filesystemobject along with a counter to...

I recently heard an interview with one of the line workers for (Ford or GM - can't remember now) and the worker was complaining about the upcoming layoffs. He tried...

As I have been reading these messages I keep thinking of different scenarios that could occur to a DBA in a "unionized" IT shop.

Pager goes off at 2 am, server...