Haha I actually had something here but I saw what I was doing wrong, apparently everyone thought it was so simple that they in fact could not answer.

I'm going to bump this to see if any early morning people can provide some insight. Thanks

Thanks for the input, but the file is stored on my local drive. I am using SQL Server 2005 SP2 and Windows XP pro SP2.

Also if anyone...

Well I should have mentioned this and hopefully this helps clarify, it is just a flat file source that I am using..

1) No

2) No

3) Yes, it is running under the same account at the moment. However in an ideal app I want it to run as a separate service.

Thanks