SSIS Package Issue

Question

User-1715638843 posted

how to run an ssis package without sql server agent?i tried through bat file,but i dont know how to pass password.I need protection level encryptwithsensitivepassword

also how i can schedule two packages to run one after another as in sql job without using that

"C:\Program Files\Microsoft SQL Server\140\DTS\Binn\DTExec.exe" /F "E:\Jinu 25-11-2018\TrustTravelsStaticDataDownloader\Sports\Importer.dtsx" > log.txt

Answer 1

User-893317190 posted

Hi jinu___,

You could use dtexec utility to help you run ssis package without sql server agent.

Please refer to

https://docs.microsoft.com/en-us/sql/integration-services/packages/dtexec-utility?view=sql-server-2017#parameter

If this still couldn't solve your problem, since it is a forum for asp.net, I suggest you could go to the ssis forum for help.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlintegrationservices

Best regards,

Ackerly Xu