SQL Server Mentalist

Hi friends ,

It had been month I have not blog .. 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 )

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

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

Output is as shown above

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

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 !!

What represent package is run successfully

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