0
3

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

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
0
3

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?