yes it works if im not using the agent.

I also tried using xp_cmdshell with T-sql step but no luck

Im getting the csv files but nothing gets inserted to the db..am i missing something with using the agent?is there a way to troubleshoot that?