To run a SSIS package outside of SQL server data tools you must install populate filecollection of integration services or higher

[indian143]

Hi, I have been going through a tough time in resolving this issue, I am getting the following error when I am trying to execute a package that's on the MSDB database, it says "Source : Microsoft.SqlServer.Dts.Runtime.TaskHost, ErrorCode : -1073679321, Description : To run a SSIS package outside of SQL Server Data Tools you must install Populate FileCollection of Integration Services or higher." My code is as below:

    static void Main(string\[\] args)
    {
        Application app = new Application();
        Package loadedPkg = app.LoadPackage(@"\\\\bsc\\cscm\\edh\_imdb\\DataExchange\\ShieldLink\\NewFolder\\Brandon\\TestSSISPackage\\SgLgReporting\_SLNewBusinessInProgress.dtsx", null);

        // Save the package to SQL Server.
        //app.SaveToSqlServer(loadedPkg, null, "WSQL569S,50101", null, null);
        app.SaveToSqlServer(loadedPkg, null, "WSQL569S,50101", null, null);

        ////Application integrationServices = new Application();
        //Package myPackage = app.LoadFromSqlServer(@"\\MSDB\\Data Collector\\SAW\\Load\_MEET\_Errors\\SgLgReporting\_SLNewBusinessInProgress.dtsx", "WSQL569S,50101", String.Empty, String.Empty, null);


        var temp = LaunchPackage("sql", string.Empty, "SgLgReporting\_SLNewBusinessInProgress.dtsx");


        //myPackage.Execute();
    }


    public static int LaunchPackage(string sourceType, string sourceLocation, string packageName)
    {

        string packagePath;
        Package myPackage;
        Application integrationServices = new Application();

        // Combine path and file name.  
        packagePath = Path.Combine(sourceLocation, packageName);

        switch (sourceType)
        {
            case "file":
                // Package is stored as a file.  
                // Add extension if not present.  
                if (String.IsNullOrEmpty(Path.GetExtension(packagePath)))
                {
                    packagePath = String.Concat(packagePath, ".dtsx");
                }
                if (File.Exists(packagePath))
                {
                    myPackage = integrationServices.LoadPackage(packagePath, null);
                }
                else
                {
                    throw new ApplicationException("Invalid file location: " + packagePath);
                }
                break;
            case "sql":
                //

[indian143]

I needed to have SSIS run time on my machine where I am executing the Console app, or reinstall SQL Server along with Integration Services.

Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."