Thanks for your suggestions Dan. I almost positive it's not the second derived column task that's failing. The numbers that appear next to the arrows in the Data...

Update: It's not directly related to file size but to how many rows fail the lookup. If over 433 rows exactly fail the lookup and go to the...

Yea it works if i hardcode the connection string into it. Also the variable is of type string. It's definitely an interesting problem. I've tried to quadruple...

The Agent is on a domain user id. So yes when running on the same credentials I can open the file.

I don't think that is the problem...

Yes I'm sure those two things are correct. As I said if I set my variable equal to the same string in the xml file manually in Business Intelligence...

I have the same setup as Asfars only I am not trying a bulk insert. I am still unsure of how to do this partially because I am new...