question

$$ANON_USER$$ avatar image
0 Votes"
$$ANON_USER$$ asked ZoeHui-MSFT commented

Sql Server Agent

Hello

I have packages on SSIS, I want to run it and do a schedule to run every day at midnight Can I use (SQL server agent) without using Management Studio, If yes what is the way to do it, and if not can you give me a way to run the packages without using any program.

Thanks

sql-server-reporting-servicessql-server-integration-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

can you give me a way to run the packages without using any program.

How can one execute a SSIS package without using any program; that's impossible, you need at least DTExec.exe to run a package.



0 Votes 0 ·

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi anonymous user,

To create a job, you may use:

SQL Server Management Studio,
Transact-SQL
SQL Server Management Objects

It seems a bit hard to create the agent job without SSMS.

create-a-job

You may run the SSIS package with from the command prompt with DTExec.exe and powershell.

Reference: ssis-quickstart-run-cmdline
ssis-quickstart-run-powershell


Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

0 Votes 0 ·

I will try the solutions you provided for me, and maybe I will want more support.

0 Votes 0 ·

Hi anonymous user,
You may click "Accept Answer" so that we could archive the case and if you want more support you can raise a new question on Q&A.

1 Vote 1 ·