September 25, 2017 at 10:38 pm
Hi there
I'm pulling my hair out with SSIS deploy problems! The problem is as follows: If I deploy a SSIS package containing C# scripts, the scripts get deployed as blank script templates and none of my C# code exists on the server. The script is still in my local DTSX file, but if I export the package from the server exported DTSX files have empty scripts.
This is using Visual Studio 2015 Community Edition, Package deploying to SSISDB on a SQL 2016 instance. No errors, no warnings, and the packages run without any problem (except the scripts don't do anything!).
My colleague has no probs and he can deploy the packages without problem.
I thought my PC build must have been causing a problem (upgrading previous versions of visual studio, etc) so I did a complete rebuild of Windows and installed VS 2015, but that didn't help.
Anyone any ideas? Here is my version list from VS 2015:
Microsoft Visual Studio Community 2015
Version 14.0.25420.01 Update 3
Microsoft .NET Framework
Version 4.6.01038Installed Version: Community
Microsoft Visual Studio Tools for Applications 2015 00322-20000-00000-AA118
Microsoft Visual Studio Tools for Applications 2015Visual Basic 2015 00322-20000-00000-AA118
Microsoft Visual Basic 2015Visual C# 2015 00322-20000-00000-AA118
Microsoft Visual C# 2015Visual C++ 2015 00322-20000-00000-AA118
Microsoft Visual C++ 2015Application Insights Tools for Visual Studio Package 1.0
Application Insights Tools for Visual StudioCommon Azure Tools 1.8
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.JavaScript Language Service 2.0
JavaScript Language ServiceJavaScript Project System 2.0
JavaScript Project SystemMicrosoft Azure Mobile Services Tools 1.4
Microsoft Azure Mobile Services ToolsNuGet Package Manager 3.4.4
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.PreEmptive Analytics Visualizer 1.2
Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.Redgate SQL Prompt 1.0
Write, format, and refactor SQL effortlesslySQL Server Analysis Services 14.0.806.134
Microsoft SQL Server Analysis Services Designer
Version 14.0.806.134SQL Server Data Tools 14.0.61707.300
Microsoft SQL Server Data ToolsSQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 14.0.800.90SQL Server Reporting Services 14.0.806.134
Microsoft SQL Server Reporting Services Designers
Version 14.0.806.134TypeScript 1.8.34.0
TypeScript tools for Visual Studio
Thanks!
Stephen.
September 26, 2017 at 9:30 am
Just curious, but after you put the C# script in place, you need to be sure that you do a "build" within the script editor. Not sure if you knew that or not, but wanted to at least mention it in case you didn't. After doing that, you exit the script editor and re-save the entire package.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
September 26, 2017 at 1:43 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply