ODBC Source in ssis
ODBC Source in ssis
have just installed the new ODBC driver 11 for SQL Server in my machine.
In this blog Post, I am going to implement a simple data transfer SSIS package using ODBC Source task. This task is available in SQL Server 2012. It helps us to integrate data from different platform and make simplified connectivity to SQL Azure.
Implementation
Step 1: Create a package and Add a data flow task
Edit this task and click new button on the dialog box
We have created the Data source configuration with ODBC 11 driver. Now, we need to connect it with SQL Server. So, next steps are for creating data source connection to SQL Server.
Data source connection to SQL Server
Give Data source name and SQL Server name.
Click finish now or you can move to next steps in the wizard to set up connection string properties. But, I am using the default settings for this connection.
We have created a new ODBC data source name. We should use this name to connect to source or destination connection in the package.
We have got two options now. We can use connection string or select the newly created data source name “AdventureWorks” in the data source selection option.
Click OK. OK.
Select a table for the data source
Step 3: Add a Data Reader Destination task and connect ODBC source task.
We have learned to configure ODBC Source task and connect with SQL Server in this blog post.
0 comments:
Post a Comment