BISQL # 86 – How to Run SSIS package in SQL Server using xp_cmdshell
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
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
‘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