Visual Studio Crash after hitting Generate SSIS Packages

Jun 21, 2013 at 3:17 PM
Edited Jun 21, 2013 at 9:06 PM
I often get a crash after hitting Generate SSIS packages. Any solutions?

Image
Full size: http://1.bp.blogspot.com/-Q7ZgyiuXP8U/UcRuVzHv6-I/AAAAAAAACQ8/krepIGCOug4/s1600/biml_generate.jpg

Version info:

Microsoft Visual Studio 2010
Version 10.0.40219.1 SP1Rel
Microsoft .NET Framework
Version 4.0.30319 SP1Rel

Installed Version: IDE Standard

Microsoft Visual Basic 2010 01011-532-2002361-70238
Microsoft Visual Basic 2010

Microsoft Visual C# 2010 01011-532-2002361-70238
Microsoft Visual C# 2010

Microsoft Visual Studio Tools for Applications 3.0 01011-532-2002361-70238
Microsoft Visual Studio Tools for Applications 3.0

Microsoft Visual Web Developer 2010 01011-532-2002361-70238
Microsoft Visual Web Developer 2010

SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 11.0.3000.0

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 11.0.2100.60

SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 11.0.3000.0

Visual Studio 2010 Shell (Integrated) - ENU Service Pack 1 (KB983509) KB983509
This service pack is for Visual Studio 2010 Shell (Integrated) - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/983509.

BIDSHelper
BIDS Helper 2012 - An add-in to extend SQL Server Data Tools - Business Intelligence (SSDTBI formerly BI Development Studio)
(c) 2013 Version 1.6.3.0
http://www.codeplex.com/bidshelper
Developer
Jun 21, 2013 at 6:01 PM
Would it be possible for you to paste the offending script into this thread or alternatively into a new thread at the varigence.com forums (which have Biml syntax highlighting)? If the script is private, you could also send it to support@varigence.com. We will be happy to debug it and figure out what is causing the crash.

Thanks,
-Scott
Jun 21, 2013 at 6:09 PM
Edited Jun 21, 2013 at 6:09 PM
srcurrie wrote:
Would it be possible for you to paste the offending script into this thread or alternatively into a new thread at the varigence.com forums (which have Biml syntax highlighting)? If the script is private, you could also send it to support@varigence.com. We will be happy to debug it and figure out what is causing the crash.

Thanks,
-Scott
Thanks for the quick reply! It's not only the script below and not only at my machine.
<#@ template language="C#" hostspecific="true"#>
<#@ import namespace="System.Data"#>
<#@ import namespace="System.Data.SqlClient"#>
<#@ import namespace="System.IO"#>
<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Connections>
        <OleDbConnection
            Name="SSISDB"
            ConnectionString="Data Source=.;Initial Catalog=SSISDB;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;">
        </OleDbConnection>
    </Connections>
    <Packages>
        <Package Name="master_all.dtsx" ConstraintMode="Parallel" AutoCreateConfigurationsType="None" ProtectionLevel="EncryptSensitiveWithUserKey">
            <Tasks>
                <# string sConn = "Provider=SQLNCLI11.1;Server=.;Initial Catalog=SSISDB;Integrated Security=SSPI;Connection Timeout=0;"; #>
                <# string sSQL  = "SELECT Packages.[name] FROM [SSISDB].[internal].[packages] as Packages INNER JOIN [SSISDB].[internal].[projects] as Projects on Packages.project_version_lsn = Projects.object_version_lsn WHERE Projects.name = 'myProject' AND Packages.name like 'STG_%' ORDER BY Packages.name"; #>
                <# DataTable tblPackages = ExternalDataAccess.GetDataTable(sConn,sSQL); #>
                <# foreach (DataRow row in tblPackages.Rows){ #>
                    <ExecutePackage  Name="EPT - <#=row["name"]#>">
                        <ExternalProjectPackage Package="<#=row["name"]#>"></ExternalProjectPackage>
                    </ExecutePackage >
                <# } #>
            </Tasks>
        </Package>
    </Packages>
</Biml>
Developer
Jun 21, 2013 at 8:39 PM
Thanks. Since it's targeting SSISDB, we should have no problem reproing. We'll debug this and get back to you shortly.
Jun 21, 2013 at 9:05 PM
Thanks! The script did work and the package was created, but right after that I got the error and visual studio was closed.