How to run SSIS package with password in Windows Scheduler?
I have an SSIS package that has the ProtectionLevel=EncryptSensitiveWithPassword and would like to run this project .dtsx file from the Windows Task Scheduler (on MS Windows Server 2012). In the task scheduler, trying to run...
"C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\DTExec.exe"
with added args
/Decrypt <mypassword> C:/path/to/my/Visual Studio/package.dtsx
(not sure if this is the right syntax for adding them)
Looking at some community docs, I think would need to use the /Decrypt <mypassword> arg, but not quite sure how to "use" it. After manually running the scheduled task, it appears to have no effect (eg. the MSSQL tables that the SSIS package is supposed to write to is still empty (despite the SSIS project running fine when running in Visual Studio)).
Can anyone with more experience with Windows know what I'm doing wrong here?
First of all you need to add /FILE or /F before the dtsx package file path:
dtexec /FILE "C:\path\to\my\Visual Studio\package.dtsx" /DECRYPT password
References
- SQL Server random selection
- How to get a Table Object by table's name by sqlalchemy and query in it？
- How to create a deterministic uniqueidentifier (GUID) from an integer value
- ExecuteReader requires an open and available Connection. The connection's current state is Connecting
- Why must some stored procedures in MSSQL be called with `master..` prepended while other can be called without it?
- Insert sorted rows in another table using SQL
- How to split a comma-separated value to columns
- How to create a table from a pivot table?
- Convert a binary representation of a number stored as VARCHAR to INT
- What is the proper use of a clustered index?
- How to wait for MSSQL in Docker Compose?
- Resolving Poor Execution Plan in SQL Server with CLR Scalar Function
- Connect python-polars to SQL server (no support currently)
- T-SQL - stored procedure - "IF EXISTS" vs. "WHERE EXISTS"
- SSISDB package errs out, says variable does not exist
- error, string or binary data would be truncated when trying to insert
- Missing libtdsodbc.so in freetds-dev - MSSQL on Ubuntu
- Conditional update either column1 or column2 or column3
- Why do I keep getting Incorrect usage of const UDF in SSMS?
- Getting statistics on a temp table in SQL Server
- Generating self-closing XML tags for lists in SQL Server
- Where value in column containing comma delimited values
- SQL Server error on update command - "A severe error occurred on the current command"
- Invalid cast error on querying the database
- Dynamic SSRS LInk
- Table function in SQL Server with multiple parameters as an argument
- Is it possible to add index to a temp table? And what's the difference between create #t and declare @t
- How do I select the first row per group in an SQL Query?
- How do I find a disabled index on SQL server 2008
- SQL Server Object Explorer not showing a database