Does anyone know what to do to SSIS package a daily automatically executed? I use SQL Server Management Studio Express 2012, VS2015 and SSDT 2015. I know in SQL Server Management Studio 2012 Express is no SQL Server Agent job, through which i could solve the problem. I'm new in ssis. Does anyone know the another way? Thank you.
Asked
Active
Viewed 721 times
1
-
Can you use a version other than SQL Express? – iamdave Oct 26 '16 at 13:01
-
Since you have no Integration Service running (that comes only with non-free SQL Server SKU), your only chance is to run Visual Studio (devenv.exe) and run your package from there. – Filburt Oct 26 '16 at 13:03
-
Unfortunately now I can not. – RInfo Oct 26 '16 at 13:04
-
Thanks for advices. Is there a SQL function to execute SSIS packages? – RInfo Oct 26 '16 at 14:03
-
Or Stored Procedure? – RInfo Oct 26 '16 at 14:16
1 Answers
1
You have to create a sql query that run ssis package and save it in a file then create a batch file that execute this file. And assign this batch file to a windows scheduler task
Look at this Topic For creating jobs in express edition
And this Topic contains how to run package from query
Hope it helps you
-
1
-
It is the only way to do it using sql express without writing an application :). If answer solved your issue mark it. – Hadi Oct 27 '16 at 07:53