Monthly Archives: March 2010

white paper on extending SSIS with expressor

SQL Server Integration Services (SSIS) ships with a lot of functionality. At some point the work involved in building and maintaining the flexibility and/or complexity required in the solution begins to cross over the cost-effectiveness line. expressor can extend SSIS by improving performance, abstracting connectivity to heterogeneous, sources and destinations, and reducing the complexity of [...]

Posted in Competition, Connectivity, expressor, Online / Multi-media | Tagged , , , | Leave a comment

why American Tower chose expressor over SSIS

This expressor customer case study webinar features Geoff Speare from American Tower, who will explain why American Tower chose expressor over SSIS for its SQL Server enterprise data warehousing project.

Posted in Competition, Connectivity, Customers, expressor, Telecommunications | Tagged , , , , , | Leave a comment

Why SMBs need better ETL / data integration software

The small-to-medium size (SMB) market is much larger than you and I might have thought.  If you look at the entire SMB market, there are millions of small and medium-size businesses worldwide.  In North America alone, there are more than a million small businesses with 20 to 99 employees and more than 250,000 mid-size companies [...]

Posted in Competition, Connectivity, expressor | Tagged , , , , | Leave a comment

improve your SSIS data integration performance

Andy Leonard’s “SSIS performance tuning, connecting to heterogeneous data sources, and complex transformations” whitepaper is now available for download on the expressor website. In his paper, Andy Leonard concludes that “SQL Server Integration Services (SSIS) ships with a lot of functionality. At some point, however the work involved in building and maintaining the flexibility and/or [...]

Posted in Competition, Connectivity, Data Processing, Data Transformation, Scripting | Tagged , , | Leave a comment

insight series: how to define parallelism in expressor

The following is an excerpt from the upcoming white paper by Microsoft MVP and SSIS guru Andy Leonard, “SSIS Performance Tuning, Connecting to Heterogeneous Sources, and Complex Transofrmations,” published by SQL Server Magazine and sponsored by expressor: …There are multiple opportunities for implementing the application in parallel [in expressor].  expressor provides dynamic parallelism at runtime [...]

Posted in Data Processing, expressor | Tagged , | Leave a comment

expressor announces reseller/SI partnership with PPC

Project Performance Corporation (PPC) will use expressor as part of its EIM framework to ensure the capture, delivery and security of high-quality information at every link of the Information Supply Chain. Read announcement. Michael Waclawiczek VP, Marketing, expressor

Posted in expressor, Partners | Tagged , , | Leave a comment

insight series: the challenge of working with heterogeneous data sources in SSIS

SQL Server Integration Services (SSIS) Connection Managers allow data integration developers to connect to heterogeneous sources and destinations. In addition to the stock connection managers that ship with SSIS, developers can build their own connection managers for custom data sources. This flexibility comes at a cost, however: it introduces complexity. Some of the complexity is [...]

Posted in Connectivity, expressor | Tagged , , , | Leave a comment