CODEWITHSUNDEEP
sql-servervisual-studio-2015ssissql-server-2012etl
RInfo
RInfo

Reputation: 79

How to SSIS package automatically executes a day?

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.

Upvotes: 1

Views: 937

Answers (1)

Hadi
Hadi

Reputation: 37368

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

Upvotes: 1

Related Questions