SSIS – Execute Process Task (Getting rid of xp_cmdshell)

Running a batch file through SSIS??

Most of us have been running commands on command prompt using SQL Server. And we know for these commands to run from SQL Server, we need to enable xp_cmdshell option of SQL Server.
Did we ever wonder why xp_cmdshell is disabled by default? I guess majority will say no.
There is a security issue attached with xp_cmdshell.
May be in your production environment, you cannot enable this option. Then what will you do? How will you run such commands?
Well, through SSIS you can achieve this task. You can write all your commands in a batch file and execute this batch file from ‘Execute Process Task’.
Now you don’t need to enable xp_cmdshell

Enjoy!!

Advertisements

2 thoughts on “SSIS – Execute Process Task (Getting rid of xp_cmdshell)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s