Home > Query, SQL > BISQL # 86 – How to Run SSIS package in SQL Server using xp_cmdshell

BISQL # 86 – How to Run SSIS package in SQL Server using xp_cmdshell

Hi friends ,

It had been month I have not blog Sad smile.. I am really missing my readers ..

Really hoping to have connected logging now onwards with you  all !!

Today we will see how we can run package from SQL Server

This is very simple in steps if you are having hands on experience on SQL Server and SSIS.

But this post will help those who are trying this first time .

The answer is in simple two steps

Step 1 :Updating SQL Server Configuration (Forget this just run script provided Winking smile)

Step 2 :Run package with dtexec in SQL Server (We have script Fingers crossed)

now lets do and run package step by step

Step :1

Run following script in SQL server

EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO

image

Output is as shown above

Now lets see what is in second step (Nothing just run it !! Sleepy smile)

Step 2 :

Run following command with your package physical address

EXEC xp_cmdshell

‘dtexec /f "C:MySSISPakageNameWithAddress.dtsx"’

Let see output how it look like !!

image

What represent package is run successfully

image

Hope you will like this post on Select All for all table.

If you really like reading my blog and understood at lest few thing then please don’t forget to subscribe my blog .

If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog

Where todays links are

Link Resource Website

About these ads
Categories: Query, SQL
  1. July 17, 2012 at 7:30 am | #1

    Sql server 2012 has stored proecedures to automate ssis I absolutely love it

  1. March 16, 2012 at 10:21 pm | #1

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

Follow

Get every new post delivered to your Inbox.

Join 1,115 other followers

%d bloggers like this: