SQL Server 2005 Integration Services Questions

1

.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?

Answer Question   |  April 16, 2009  9:40 AM
SQL Server 2005 Express, SQL Server 2005 Integration Services, SQL Server Integration Services, SSIS 2005
asked by:
30 pts.

asked by:
30 pts.

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.

Answer Question   |  November 6, 2008  12:57 PM
Business Intelligence, SQL Server 2005, SQL Server 2005 Integration Services, SQL Server Integration Services, SQL Server stored procedures, SSIS Package, Stored Procedures
asked by:
5 pts.

1