John Rowan (5/5/2016)
Is the connection manager parameterized? It may be that it works in BIDS because your parameters are filled out, but the package may not have the parameters configured on the SQL Agent job.
No the Connection Manager is not Parametrized.
The Network Administrator gave me saparate Credentail for Domain YYY, that i used when i created File Connection manager meaning when i try to map the directory, small window pops up and ask about username and password to access the directory on domain YYY. i put in the Credential and thats how the connection established and run through the BIDS, same package i try to schedule through SQL Agent and it errored out.