SQL Server Mentalist

Home | Pages | Archives

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

March 11, 2012 7:50 pm

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

Stay Tuned :

Posted by Vishal Pawar

Categories: Query, SQL

Tags:

3 Responses to “BISQL # 86 – How to Run SSIS package in SQL Server using xp_cmdshell”

  1. […] BISQL # 86 – How to Run SSIS package in SQL Server using xp_cmdshell (sqlmentalist.com) 0.000000 0.000000 Share this:TwitterTumblrDiggFacebookPrintLinkedInStumbleUponRedditEmailLike this:LikeBe the first to like this post. […]

    By More SQL Commands « My Journey Into Microsoft Access and WordPress on March 16, 2012 at 10:21 pm

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

    By aaron on July 17, 2012 at 7:30 am

    1. yes !! Me too !!

      By Vishal Pawar on July 17, 2012 at 8:16 am

Leave a Reply

Mobile Site | Full Site

Get a free blog at WordPress.com Theme: WordPress Mobile Edition by Alex King.