SQL Server Integration Services

SSIS Import from Multiple Databases

How do I iterate over a series of databases with identical structure and import from a seris of tables within each using the SSIS ForEach facility?

.dts and .dtsx config files in SQL Server 2005

Hi I have .dts and .dtsx config files. i want to execute these packages in the db server, can u tel me what are the steps required to attach and configure these packages for it to execute?

Execute SSIS package in SQL Server 2005

how to execute SSIS package in sql server 2005

Tool for migrating DTS to SSIS

What is the tool for migrating dts to ssis.And how effective it works.And I want migtate 500DTS packages to ssis how much time it will take?

Delete names from an email list in SQL Server Integration Services

How can I delete names from an email list in SQL Server Integration Services?

SSIS and Microsoft Excel

I have a road block that I need to find a work around for. I work on a system where the Databases reside on a soley database server (SQL 2005). I need to run a stored procedure on a nightly basis and export the results into a template excel file and put out on shares. Sounds simple right? Here's...

SQL Server 2008 SISS error row handling

Struggling with SISS I have data source and data destination With some bad data, I can't figure out how to set up sending the bad row to another destination There are over 50 columns. Sorce is a tab delimited text file Desitnation is SQL Table

Running SSIS on a clustered server with SQL Server 2005

We are using SQL Server 2005, 64-bit, on a Windows 2003 clustered server with Active/Passive 'A' and 'B' nodes. Databases are on a shared LUN. I can run all my SQL Server Integration Services packages on the 'A' node with no problem. When we fail over to the 'B' node, though, packages are...

SSIS package

I am supposed to Run an sproc /script for more than one database. I thought of scheduling this sproc as a job for all database instances. But, DBA's suggested me to go with SSIS Package. Can any one quide me in doing this.

How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.

How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.