LoginSignup
0
3

More than 3 years have passed since last update.

@wcathy007

SqlServer_SSISパッケージ

Posted at

拡張子：.dtsx
①「SQL Server Business Intelligence Development Studio」で開き、変更できる。
②テキストで開き、変更できる。
下記はパスワードを非暗号化に変更する設定です。

<DTS:Property DTS:Name="Retain">0</DTS:Property><DTS:Password DTS:Name="Password" Sensitive="1" Encrypted="0">password</DTS:Password>

バッチで実行

DTEXEC.EXE /F "import.dtsx"

2.png
3.png

0
3
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
0
3