Hi @Lovedeep Singh ,
The OLE DB destination provides five different data access modes for loading data:
- A table or view. You can specify an existing table or view, or you create a new table.
- A table or view using fast-load options. You can specify an existing table or create a new table.
- A table or view specified in a variable.
- A table or view specified in a variable using fast-load options.
- The results of an SQL statement.
Please use fast-load options when choose data access mode in OLEDB Destination.
Best Regards,
Mona
----------
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?