I have a query which selects rows from source database. The query casts certain columns into Varchar.
But the columns in destination are nVarchar. This works fine when I execute the package from my machine. But when the package is executed using autosys Scheduler it fails.
Does anyone have any idea why this happens