asked on

How SSIS Package Oledbdestination check constraints option works?

Hi,
I am having SSIS Package that does incremental data loading. I am using
SSIS OLEDBDestination fast load options. I am having Check Constraints option selected while inserting hundreds of records into table.

It gives the error:

Bulk copy failed user does not have alter table permissions.

Máté Farkas

My hints:

Don't use FAST LOAD option. or
Use ADO.NET Destination instead or
Give dbo permission to the user which connects to the database in destination component

Saroj13

ASKER

I am doing incremental data loading from Source database to Target Database.

I am using oledbsource, lookup, oledbdestination. It gives the issues when data is trying to insert into target database. Target table is having foreign key and constraints.
I am not able to use Ado.net destination on target because I am using oledbcommand and lookup.

I tried oledbdestination without fast load, its giving identity issue. I need to insert data with the identity key from source to target database.

Currently, I am getting the issue when running SSIS PAckage
Cannot find the object "dbo.xxx" because it does not exist or you do not have permissions.

Please let me know what needs to be done.

This question needs an answer!

Become an EE member today

7 DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform.

View membership options

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.