Home > SSIS > ODBC Destination – SSIS

ODBC Destination – SSIS


ODBC Destination task is used as a data source destination task in SSIS package. ODBC supports bulk upload. So, we can upload data faster now. There are two data loading options available in this task.

  1. Batch – It is the most efficient insertion method. It is manged by batch size value. If batch method is not supported by the provide then it chooses Row by Row option automatically.
  2. Row-by-Row – This method uses SQL Execute function to insert rows one at a time.

Implementation

I am going to use my old package that I used in my previous blog post. I have already create a table for the destination task. Because, we cannot create destination table in design mode as we can do with OLE DB or ADO Net.

Step 1: Add ODBC destination task and connect with ODBC source

pic1Step 2: Edit ODBC destination task and select data source, table and map columns between source and destination.

pic1

Mappings

pic1We have configured the ODBC destination task.

Step 3: Execute package.

pic1We have learned to use ODBC destination task in this blog post.

Advertisements
  1. Toney Brunecz
    March 4, 2016 at 7:53 am

    I’ve been looking using the net quite three hrs today, but under no circumstances spotted any attention-grabbing content similar to your own. It really is eye-catching worth enough in my view. In my personal opinion, if many website owners and bloggers crafted very good content resources you did, the online market place will most likely be far more helpful than everbefore.I’m going to book mark this site !! Will surely browse for a second time !! Thanks with the valuable info.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: