a direct execute works. but when in a step in a job, it says
"String or binary data would be truncated. [SQLSTATE 22001] (Error 8152) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed."
by executing in as it is with an exec command, i have confirmed that the logic is good. i confirmed that the data manipulation has happened correctly also :
it is basically an insert statement
insert into database2....tablename
select ......... from ......
in the step in the job, it is executing from database1.
do you think it is a data tpye issue, and if so, why only from the job or from direct execution?