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

March 11, 2012 Leave a comment Go to comments

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

Advertisement
Categories: Query, SQL
  1. aaron
    July 17, 2012 at 7:30 am
    Reply

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

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

Leave a Reply

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

Gravatar
WordPress.com Logo

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

Facebook photo

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

Cancel

Connecting to %s

%d bloggers like this: