Thanks a lot Erik and Tom. Very helpful!!!

I very appreciate!

...

anyone?

The last task following all execute process tasks is a Send Mail task. So, back to matter I'm requesting assistance on (NOT the SSIS package).

Is there a way...

Hi Jeff,...

Yes Execute Process Task works great!:-D

Thanks so much for discovering and testing that. I didn't think to try that even tho error said it came to end of document without finding end of row. I...

Can you please see if you can do a straight across pull?

<<<I've attached one of the files I'm trying to consume. Can you please try straight pull...

Phil, yes, I did and no data leaving FF Source so nothing to examine even. Preview in flat file connection manager showing data as it should be.

I have read...

Using BIDS 2005, and I am having exactly the same problem, but in my case Flat Files (txt) are the source. Have left default at zero rows to skip....

found answer here

http://social.msdn.microsoft.com/forums/sqlserver/en-US/9f7df754-d766-49b8-833d-001d32217e23/open-file-security-warning

"It's an attribute of the file. Right click on the file you trying to run, got to properties, click on the Unlock button at the bottom of the...

...

http://www.sqlis.com/sqlis/post/Have-you-used-the-ExecutionValue-and-ExecValueVariable-properties.aspx Can I apply the steps here to Process task to return error back to ssis?

Can you explain your wsy in a little more detail? Looks like you're suggest ing parameterizing this and that looks promising!! Are you saying to parameterize the row_number column?...