SSIS package
Home > IT Answers > DataManagement > SSIS package
MSDEVELOPER
5 pts.
0
Q:
SSIS package
Business Intelligence, Stored Procedures, SQL Server 2005, SQL Server stored procedures, SSIS Package, SQL Server Integration Services, SQL Server 2005 Integration Services
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.
ASKED: Nov 6 2008  12:57 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46765 pts.
0
A:
 RATE THIS ANSWER
-1
Click to Vote:
  •   0
  •  -1
  • AddThis Social Bookmark Button
Without more information as to what the job is suppose to do, not really.
Last Answered: Nov 6 2008  6:13 PM GMT by Mrdenny   46765 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46765 pts.  |   Nov 6 2008  6:13PM GMT

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

 
0