[PL] SQL Server Integration Services (SSIS) w praktyce - transformacja Import i Export column

Dzisiaj publikuję kolejne nagranie z cyklu "SQL Server Integration Services (SSIS) w praktyce". Tym razem, przedstawiam zagadnienia dotyczące wykorzystania transformacji Data Conversion.

[EN] Setup Failed while SSDT installation - how solve this problem?

Recently, when I try did install SSDT for Visual Studio 2015 on Windows Server 2016, I did  have problem that appear error screen with description "Setup Failed" and following error messages in log file:

 [12AC:0C58][2018-09-08T23:48:58]: Error 0x80072f08: Failed to send request to URL: https://go.microsoft.com/fwlink/?LinkId=832089&clcid=0x409
[12AC:0C58][2018-09-08T23:48:58]: Error 0x80072f08: Failed to send request to URL: https://go.microsoft.com/fwlink/?LinkId=832089&clcid=0x409
[12AC:0C58][2018-09-08T23:48:58]: Error 0x80072f08: Failed to connect to URL: https://go.microsoft.com/fwlink/?LinkId=832089&clcid=0x409
[12AC:0C58][2018-09-08T23:48:58]: Error 0x80072f08: Failed to get size and time for URL: https://go.microsoft.com/fwlink/?LinkId=832089&clcid=0x409
[12AC:0C58][2018-09-08T23:48:58]: Error 0x80072f08: Failed attempt to download URL: 'https://go.microsoft.com/fwlink/?LinkId=832089&clcid=0x409' to: 'C:\Users\ADMINI~1\AppData\Local\Temp\2\{f3809ec7-e8e2-4989-98a4-0f68d25f7568}\VSTALS2015'

Cause of problem was Internet Explorer Enhanced Security Configuration (IE ESC).  After temporary disable IE ESC in Server Manager setting, SSDT was install without errors.

[EN] SQL Server 2016 SP2 / SSDT 2015 - why Azure group is greyed out?

If we have environment, in which are SQL Server 2016 SP2 and SQL Server Data Tools 2015 and after install Azure Feature Pack for Integration Services (SSIS), the Azure group is disabled in the SSIS Toolbox, then we should change value of TargetServerVersion parameter into SQL Server 2016 in the properties of the our SSIS project.

 

[PL] SQL Server Integration Services (SSIS) w praktyce - zmienne

Dzisiaj publikuję kolejne nagranie z cyklu "SQL Server Integration Services (SSIS) w praktyce". Tym razem, przedstawiam zagadnienia dotyczące wykorzystania zmiennych

[PL] SQL Server Integration Services (SSIS) w praktyce - transformacje Union All oraz Merge

Dzisiaj publikuję kolejne nagranie z cyklu "SQL Server Integration Services (SSIS) w praktyce". Tym razem, przedstawiam zagadnienia dotyczące wykorzystania transformacji Union All oraz Merge.