In SSIS how to load the package inside Script Task c# code

Question

In SSIS Script task I am able to load the package by providing the full path as following, but on the server I don't know the exact path after deployment, Is there any way to load the package and its configuration file.

    public void Main()
    {
        Dts.TaskResult = (int)ScriptResults.Success;
        Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
        Package package = app.LoadPackage(@"C:\tfs01\AURA\DB\Main\Src\ReportSolution\AURA_ETL\AURA_ETL\DTS_PatientModel.dtsx", null);
    }

Community · Accepted Answer · 2017-05-23 12:05:19Z

1

As always, the documentation is your friend.

Instead of calling LoadPackage, you need to use LoadFromSqlServer. LoadPackage pulls from disk, LoadFromSqlServer talks to the msdb.

Note that if you are working with the 2012 project deployment, it's an entirely different mechanism.

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered Aug 19, 2013 at 14:07

billinkc

61.4k10 gold badges110 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

In SSIS how to load the package inside Script Task c# code

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related