Setup Dataflow Tasks in the SSIS Package - SQL Resources - SQL Programmers Chicago

Send a Message


 

 

 


 
  

Need help with Microsoft SQL Server? Ask our Experts, or simply Email your query.

About Sql Server Programmers

Our clients can be found both locally in the Chicagoland area and throughout the country. We have over 18 years of experience and are extremely proud of our track record of successfully assisting hundreds of our clients to improve their productivity while focusing on cost.

Microsoft Certified Partner

  

Setup Dataflow Tasks in the SSIS Package

  • Select the Package1 from the solution Explorer
  • Rename Package1 to “Company”.

    SSIS Steps

  • Now you can see four tabs in Company.dtsx package at the top:
    • Control Flow
    • Data Flow
    • Event Handlers
    • Package Explorer.
  • In the bottom line you can see two connection managers for source and destination:
    • DestinationConnectionOLEDB
    • SourceConnectionOLEDB.
  • Click the Data Flow from the tab and there will be three boxes on the page.

    SSIS Steps

    • The first box is the source, that is our MS Access.
    • The next one is the Data Conversion.
    • Double click on the Data Conversion box.

    SSIS Steps

    • Before transferring the data from Access to Sql Server we have to do a conversion. The system will do it automatically because we have chosen wizards.
    • In the Access table I have the following structure.

    SSIS Steps

    • There are two text fields and one Memo field.
    • In SQL Server, I have the following structure:

    SSIS Steps

    • There are two varchar fields and one text field.
    • So the conversion should be done.
    • Click Ok
    • Click F5; the packages will be executed and the data will be transferred from Access to the Sql Server database.

    SSIS Steps

    • Next you will get the above diagram. Here the message is that 3 rows are imported.
    • Now go to Sql Server and you can query against the table company.

    SSIS Steps

    • The records are now displayed.

    For each Loop Container in an SSIS Package >