An SSIS Express with ASE ADO.NET 2.0 and Bulk Load

    By: Paul Vero on Jun 01, 2013

    Many companies deploy multiple databases in the enterprise and consequently utilize various tools to perform critical tasks. In the Windows drivers world for the ASE many customers also work with Microsoft SQL Server. If you’ve worked with SQL Server before you might know, there are some developer tools integrated with Visual Studio to assist with some data migration and movement. I’m referring to SSIS, SQL Server Integration Services. It’s a development platform to create applications proving data integration and transformation services.

    In the context of this article, I focus on using SSIS to move data from the SQL Server to the ASE. In some instances, massive amounts of data are involved and time is of the essence.

    For some background, I used SSIS with SQL Server 2005 back in the old days, creating SSIS packages in Visual Studio 2005 when testing and reproducing various customer problems. The ASE component to connect and transfer data, the ASE OLE DB Provider, proved adequate for nominal data movement and transformation but when moving large volumes of data in the order of hundreds of thousands of rows into the millions, the performance isn’t there. Typically, the OLE DB Provider transforms the source data, retrieved by SELECT command, into INSERT commands. For smaller tables this works great but larger volumes time becomes critical.

    At some point Microsoft introduced the use of ADO. NET providers for source and destination targets. When the demand arose to increase performance for the ASE as a target of data transfer, our engineers implemented a bulk load capability by using the ASE ADO.NET Provider AseBulkCopy class. In order to make this a reality a separate ASE specific destination component is provided recognizing the bulk load feature, effectively moving data in minutes, even seconds, instead of possibly hours. Follow along to learn how to achieve this goal.

    Login to read the article. Not a member? Create a free account!

    Released: June 1, 2013, 8:30 am | Updated: January 27, 2014, 8:02 pm
    Keywords: ASE Developer Article | Technical Journal | ASE | ASE 15.7 SP100 | ASE ADO.NET 2.0 Provider | bulk load | Development | Paul Vero


     

     

    TwitterLLinkedinLFacebook

    Copyright © 2014 ISUG-TECH. All Rights Reserved
    All material, files, logos and trademarks within this site are copyright their respective organizations

    Terms of Service - Privacy Policy - Contact the Help Desk