"String data trunc.." error on first SSIS run and no error on 2nd -
01-30-2009
, 11:38 AM
Hi,
I have SSIS package wich executes a stored procedure using ExecuteSQL task
to load data from staging to main tables and A SQL Agent job runs the package.
When I execute the package first time it gives me "String or binary data
would be truncated" error and fails...but subsequesnt runs with same data
succeeds.
Any idea??
Thanks in advance!! |