Home Forums Data Warehousing Integration Services can not run SSIS package with script task when deployed to SQL Server under MSDB RE: can not run SSIS package with script task when deployed to SQL Server under MSDB

  • Here are the contents of MsDtsSrvr.ini

    I found it under E:\Program Files\Microsoft SQL Server\110\DTS\Binn

    <?xml version="1.0" encoding="utf-8"?>

    <DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

    <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>

    <TopLevelFolders>

    <Folder xsi:type="SqlServerFolder">

    <Name>MSDB</Name>

    <ServerName>.</ServerName>

    </Folder>

    <Folder xsi:type="FileSystemFolder">

    <Name>File System</Name>

    <StorePath>..\Packages</StorePath>

    </Folder>

    </TopLevelFolders>

    </DtsServiceConfiguration>

    I also saw this in the services window:

    SQL Server Integration Services 11.0 started automatic

    Microsoft .NET Framework NGEN v2.0.50727_X64 Disabled

    Microsoft .NET Framework NGEN v2.0.50727_X86 Disabled

    Microsoft .NET Framework NGEN v4.0.30319_X64 Delayed start with no status

    Microsoft .NET Framework NGEN v4.0.30319_X86 Delayed start with no status

    Would .net service have anything to do with this error.

    I can run the package without error if I remove the script task.

    I am using C# in the script task to assign value to a variable.

    Thanks for your help.

    Forum User:cool: