SSIS OLEDB destination not picking up default value from Schema

SQL 2005 / BIDS

We have an SSIS package that transfers data from one table to another . When we add a new columns to the destination table that does not allow nulls and set a default value, SSIS doesnt pick this up.

When we insert into this table from SQL or an app, the default value is applied so tha apps dont need editing, but when we put data in via the SSIS package he routine fails and we have to edit the task to add in the mapped column with the same value as the default.

Is this a bug in SSIS or something we are doing wrong
ASPDaddyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tony303Commented:
What is the setting in the connection manager for the destination?
Look at the connection manager tab, "allow nulls"checkbox.
0
Tony303Commented:
I meant the "keep Nulls" checkbox.
KeepNulls.jpg
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ASPDaddyAuthor Commented:
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.