Soft82.com » Windows » Business » Database Management » DataDefractor SSIS 1.1 SR-7

View screenshots

DataDefractor SSIS Description

A custom SQL Server 2005 Integration Services (SSIS) data flow source component designed specificall

It helps import complex business Excel and CSV spreadsheets into the SSIS pipeline. It converts the input spreadsheets into structured normalized data output which is pumped directly into the SSIS data flow pipeline. DataDefractor SSIS integrates with SQL Server Business Intelligence Studio.View DataDefractor SSIS demo




The following diagram demonstrates the execution workflow of an SSIS package which uses the DataDefractor SSIS data flow component:

DataDefractor - How it works

1. DataDefractor SSIS uses a standard SSIS connection manager to connect to one or more sample spreadsheets.
2. In design-time, the SSIS developre uses DataDefractor Mapping Wizard to define a dimensional model and a data mapping schema based on the sample set of worksheets. During run-time DataDefractor SSIS uses this schema to parse and convert the input spreadsheets into a structured data model which is pumped directly into the SSIS output pipeline in the form of a star schema.
At this point, the output can be transformed, mapped to existing data structures, used to create new data marts or be appended to existing data warehouse schemas using standard SSIS data flow transformation and destination components.

Additional DataDefractor SSIS features include:

* 64-bit platform support
Unlike the standard Excel SSIS source, DataDefractor SSIS was specifically designed to support the 64-bit edition of SSIS.
* Support for the new Excel 2007 format
DataDefractor SSIS extracts data from the new Excel 2007 OpenXML format by using direct XML-package access.
* Support for Excel 2000-2003 binary format
DataDefractor SSIS performs low level BIFF read to access the bynary Excel file format. It does not need legacy ISAM drivers or Excel components to be installed on the target machine.
* Advanced Excel formatting options
DataDefractor SSIS provides a wide variety of options to interpret Excel formatting. It resolves the formatting issues associated with the standard SSIS Excel data flow source.

DataDefractor SSIS Limitations

14 days trial

DataDefractor SSIS Download Button For Your Site

If you want to place a Download Button for DataDefractor SSIS on your website just insert the following code:

If you want a Link to this page you can use one of the logos bellow:

DataDefractor SSIS User Reviews

New Database Management Software

QueryToDoc May 21, 2012 Use QueryToDoc to export SQL Server and Oracle query results to a Word, HTML, or CSV File				DataSlave May 21, 2012 Import, Validation and Transformation of Data
Universal SQL Editor May 17, 2012 Intellisense enabled SQL editor for Oracle, DB2, SQL Server, Sybase, etc.				DTM DB Stress May 16, 2012 DTM DB Stress is a utility for database and db-applications stress testing
SB Solutions May 15, 2012 BAAC offers Small Business Database SW for managing Contacts and Accounting				ActiveData For Office/SQL Edition May 14, 2012 A Windows application that leverages the power of Microsoft Office and SQL databases
MONyog MySQL Monitor May 11, 2012 MONyog helps MySQL DBAs manage more MySQL servers, tune their current servers				MDB Viewer Plus May 10, 2012 View and edit the content of .mdb files without the need to have Microsoft Access installed
PHPRunner May 9, 2012 PHPRunner creates set of PHP pages to access and modify any MySQL database				X-SQLT May 9, 2012 A free-form, declarative, XML-based language used to describe a series of commands for data
TirePrices May 8, 2012 Click on Mfg., or Size, or Type, or Misc. Code to see 3 pricing levels				DBConvert for MS SQL & MySQL May 8, 2012 DBConvert for MS SQL & MySQL - Bi-directional db conversion tool for MS SQL and MySQL databases
GeniusConnect May 8, 2012 Add database connectivity to Outlook or Exchange				B&B Quick Quote May 3, 2012 Quick Quote displays the costs (labor or parts/products) from a selected job
phpMyAdmin May 2, 2012 phpMyAdmin is a tool written in PHP used to administrate MySQL databases				My Money May 2, 2012 My Money is a high quality personal financial software written from ground up
dotConnect for MySQL April 25, 2012 An enhanced data provider for MySQL that builds on ADO.NET technology to present a complete				DBSync for MS Access & MSSQL April 24, 2012 Bi-directional synchronization and convertion for MS Access and MS SQL Server
CDBF - DBF Viewer and Editor April 20, 2012 Easy to use, very fast and small DBF viewer and editor				DBF Manager April 19, 2012 Manage DBF files easily using this innovative tool! Free trial version available

Last 7 Days Most Downloaded Database Management Products

MySQL Workbench 156 downloads Visual database design application that can be used to efficiently design, manage				TOAD for Oracle Freeware 40 downloads Tool for Oracle Application Developers
QI Macros 35 downloads Draws pareto charts, control charts, histograms, box and whisker plots, scatter plots and more				Mobile DBViewer Plus for Nokia S60 3rd E 35 downloads View & Sync any database with Nokia S60 3rd Edition phone. Create DB on mobile.
HotRez 23 downloads The Hotel Reservation Software HotRez is a Room Booking Software for Hotels				smart report maker (MySQL Report Generator) 17 downloads Create and manage unlimited number of MySQL Reports
SQLyog MySQL GUI 16 downloads SQLyog is a tool that allows you manage MySQL database				Pabx Billing System and Hotel Management 14 downloads Compatible with any PBX, 54 bills for Pabx Billing feature, 12 bills for Hotel
Full Convert Enterprise 13 downloads Full Convert is the best application to convert structure and data of databases.				DBF Viewer 2000 13 downloads Powerful viewer and editor for DBF files (Clipper, dBase, Foxpro, VFP, DB2K...)

All Time Most Downloaded Database Management Products

MySQL Workbench 19,567 downloads Visual database design application that can be used to efficiently design, manage				TOAD for Oracle Freeware 14,510 downloads Tool for Oracle Application Developers
QI Macros 722 downloads Draws pareto charts, control charts, histograms, box and whisker plots, scatter plots and more				Mobile DBViewer Plus for Nokia S60 3rd E 11,066 downloads View & Sync any database with Nokia S60 3rd Edition phone. Create DB on mobile.
HotRez 3,949 downloads The Hotel Reservation Software HotRez is a Room Booking Software for Hotels				smart report maker (MySQL Report Generator) 252 downloads Create and manage unlimited number of MySQL Reports
SQLyog MySQL GUI 4,755 downloads SQLyog is a tool that allows you manage MySQL database				Pabx Billing System and Hotel Management 345 downloads Compatible with any PBX, 54 bills for Pabx Billing feature, 12 bills for Hotel
Full Convert Enterprise 2,338 downloads Full Convert is the best application to convert structure and data of databases.				DBF Viewer 2000 1,957 downloads Powerful viewer and editor for DBF files (Clipper, dBase, Foxpro, VFP, DB2K...)