SQL Server Integration Services (SSIS)
Home
Options
886
Chunhua on 05-24-2020 05:08 PM
1,104
Chunhua on 05-11-2020 11:22 PM
1,731
Sandy Winarko on 12-31-2019 06:09 PM
1,816
Sandy Winarko on 12-12-2019 01:58 AM
3,556
Chunhua on 12-05-2019 04:21 PM
1,643
Chunhua on 11-25-2019 12:33 AM
2,696
xichen on 10-29-2019 08:40 PM
2,534
Lingxi on 08-29-2019 10:23 PM
3,145
Jarod_Zhu on 08-08-2019 11:31 PM
2,502
qianwen_shi on 08-06-2019 02:23 AM
13.2K
Tim.Chen on 05-14-2019 01:19 AM
3,063
Sandy Winarko on 03-25-2019 04:11 PM
1,432
SSIS-Team on 03-25-2019 04:10 PM
4,100
Sandy Winarko on 03-25-2019 04:09 PM
1,954
Sandy Winarko on 03-25-2019 04:08 PM
1,787
SSIS-Team on 03-25-2019 04:08 PM
972
SSIS-Team on 03-25-2019 04:08 PM
3,726
SSIS-Team on 03-25-2019 04:08 PM
892
SSIS-Team on 03-25-2019 04:08 PM
2,543
SSIS-Team on 03-25-2019 04:08 PM
817
SSIS-Team on 03-25-2019 04:07 PM
Latest Comments
What about Azure SQL DB? Or Azure Synapse (formerly known as...)?
0 Likes
Hi @ykhabins , I suppose that your purpose of executing package in SSDT is to help design the package. So I think you can set the protection level to other options in designing phase. After finishing package design, you can set the protection level to DontSaveSensitive and run the packages elsewhere...
0 Likes
Hi @Junxiao_Ma, We don't want to save the password in the package, that's why we set package ProtectionLevel as DontSaveSensitive. We also tried to use Oracle connection parameterization (right mouse click, select "Parameterize..." option), and set both UserName and Password through that. Unfortunat...
0 Likes
@ykhabins please set the package protection level to options other than DontSaveSensitive. DontSaveSensitive option will not save password in the package which causes connection error during package execution in SSDT.
0 Likes
My environment:- VS2019, v.16.4.6- SSIS Integration Services Projects for VS2019, 15.0.2000.94- Microsoft Connector for Oracle, v.2019.150.2000.110 (both editions 32-bit and 64-bit)- MS SQL Server is NOT installed on my machine- Oracle Client is NOT installed on my machine SSIS project settings:- SS...
0 Likes