Home > IT Answers > Business Intelligence > SSIS package
MSDEVELOPER
5 pts.
 SSIS package
Business Intelligence, SQL Server 2005, SQL Server 2005 Integration Services, SQL Server Integration Services, SQL Server stored procedures, SSIS Package, Stored Procedures
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.

Software/Hardware used:
ASKED: November 6, 2008  12:57 PM
UPDATED: November 6, 2008  6:13 PM
RELATED QUESTIONS
Answer Wiki:
Without more information as to what the job is suppose to do, not really.
Last Wiki Answer Submitted:  November 6, 2008  6:13 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.