SSIS error:
solution
http://www.mssqltips.com/tip.asp?tip=1393
#database side
1) change the column width in database table for the error coulumn.
#SSIS package side
1) Right click 'Flatfile editor' and select 'Advanced' editor
2) Go to 'Input & Output Properties'
3) Expand 'Flat File Source Output
4) Expand the 'Output columns'
5) Select Error column and change the length.
-- Yup, refresh you're OLEDB connection with updated table information.
ready to go...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment