Wednesday, March 21, 2012

Running SSIS package

My boss want to close access to xp_cmdshell for any logins including sa.
He afraid of possible fraud when somebody having sa login will be able to make operations on the company's network.

In this situation (see above) I have two questions:

1. Is it possible to run SSIS package by SQL Job without corresponding utility?

2. Is there any replacement of the osql.exe utility in order to run file containing sql script? I mean may be SSIS can load the file and run content of this file by SQL Task?

Let's discuss.

Any ideas will be greately appreciated.

Vitaliy

Yes - to both questions.

No comments:

Post a Comment