Copy Data from SQL Server to OLE DB Automatically

1. Launch Advanced ETL Processor

• Create a SQL Server Connection with server details, authentication type, and database name
• Create an OleDb Connection using the appropriate provider string and file path (if applicable)

2. Create a New Transformation

Right-click on any transformation group and select New to build your workflow.

3. Configure Reader

• Double-click the reader to open Reader Properties
• Select your SQL Server connection
• Choose the table or write a custom SQL query

4. Configure Writer

• Double-click the writer to open Writer Properties
• Select the OleDb connection
• Choose the target table and write mode (append, truncate, replace)

5. Map and Format Fields

• Match SQL Server fields to the OleDb destination columns
• Apply type conversions or transformations if needed

6. Run the Transformation

Click the Run button (Green Arrow) to initiate the transfer. Data will be copied from SQL Server to the OleDb destination with full logging and error handling in place.