anushahanna
asked on
proc works in SSMS but not job
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
delete database2....tablename
use database1
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?
thanks
"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
delete database2....tablename
use database1
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?
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ia2189- it was a tricky place where there was a overflow of characters, which in some data runs - so it was a data issue. thanks for the clue and which made it easy to look out for it.
ASKER
regardless, if this is the issue, it should fail in a regular exec procname format also, right?