dbTalk Databases Forums  

"String data trunc.." error on first SSIS run and no error on 2nd

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss "String data trunc.." error on first SSIS run and no error on 2nd in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
xyz_jat
 
Posts: n/a

Default "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!!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.