Job truncates text data type

I have a table with a text data type and when I run my sql manually,
everything works fine - the text column is completely filled with what
I need (it's html from a http post request via a stored procedure).
When I put the exact same SQL inside a job, and kick the job off (or
let the agent pick it up on the schedule), it truncates the text column
to a width of 498, rendering my later job steps useless b/c the
expected data isn't there.
Why would the job cutoff the text in this column?What is the syntax used in the proc? Are you issuing an update/insert
or a writetext/updatetext statement?

Job truncates text data type

I have a table with a text data type and when I run my sql manually,
everything works fine - the text column is completely filled with what
I need (it's html from a http post request via a stored procedure).
When I put the exact same SQL inside a job, and kick the job off (or
let the agent pick it up on the schedule), it truncates the text column
to a width of 498, rendering my later job steps useless b/c the
expected data isn't there.
Why would the job cutoff the text in this column?What is the syntax used in the proc? Are you issuing an update/insert
or a writetext/updatetext statement?

job fails

I have a DTS job that runs every hour.
it truncates destination table and copies from the source table.

it has failed with the following error in view job history

"error-214721900(80040E14);provider error 14262.(37B6)"
error source Microsoft ole db provider error
pls help in this

how can i solve this, i tried restarting the job but its failing again.look here

http://support.microsoft.com/default.aspx?scid=kb;en-us;223758

Originally posted by aadil
I have a DTS job that runs every hour.
it truncates destination table and copies from the source table.

it has failed with the following error in view job history

"error-214721900(80040E14);provider error 14262.(37B6)"
error source Microsoft ole db provider error
pls help in this

how can i solve this, i tried restarting the job but its failing again.|||Also

http://search.microsoft.com/search/results.aspx?st=b&na=83&qu=80040E14&View=en-us

Originally posted by aadil
I have a DTS job that runs every hour.
it truncates destination table and copies from the source table.

it has failed with the following error in view job history

"error-214721900(80040E14);provider error 14262.(37B6)"
error source Microsoft ole db provider error
pls help in this

how can i solve this, i tried restarting the job but its failing again.|||Also this KBA http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074 to schedule DTS as job and resolve the issue.