Thanks for the help, I actually used the same method through execute SQL task (openquery) instead of using Data Flow Task. Data flow task isn't working if directly querying from...
Maybe you can try changing the Log On for your SQL Server Agent Service Account, with the current user you are using, whether Local administrator or Domain user (also an...