dbta

Upcoming Webinar Shows How to Move MV Data to SQL Server using BlueFinity's mv.SSIS

BlueFinity will demonstrate how to create a simple SSIS transformation to move MultiValue data into Microsoft SQL Server using mv.SSIS in a free webinar on Tuesday, January 31. Microsoft SQL Server's ...
Houston Chronicle

How to Change an Execute SQL Task in SSIS

Execute SQL tasks run stored procedures or SQL queries from SSIS packages. A task executes any SQL statements that have been passed to it in sequential order. It provides you with a handy way to store ...
dbta

Attunity Introduces Operational Data Replication for SQL Server Integration Services

Attunity, a provider of real-time data integration and event capture software, has introduced a suite of Operational Data Replication (ODR) solutions integrated with Microsoft SQL Server Integration ...
Ars Technica

Exporting SQL data to Excel spreadsheet via web page click

I would like the user to be able to click a button on the web page that will run a SQL query (canned report) and export the result data to an Excel spreadsheet. The data does not need to display on ...