CODEWITHSUNDEEP
c#sql-serverssisetldtexec
Willimar
Willimar

Reputation: 71

Console application execute Dtsx file with error -1073679321

My code have not a problem. I know that because to console application don't execute only in my machine. Basically I load the package and after execute.

I tried:

Services status

Below the code, but have not error.

    using Microsoft.SqlServer.Dts.Runtime;

    public void Execute()
    {
        Database database = DatabaseFactory.CreateDatabase("MyConnection");

        try
        {
            parametrosConfig = new ParametrosConfigBatch();
            string strPathPacote = parametrosConfig.PathDTSX;

            DataTable _dt = new DataTable();
            _dt = GetMyDataTable();

            package = app.LoadPackage(strPathPacote, null);

            Variables myVars = package.Variables;

            package.Variables["User::varArquivo"].Value = _dt;

            dtsResultado = package.Execute(null, myVars, null, null, null);

            if (dtsResultado == DTSExecResult.Success)
            {
                ...
            }
            else
            {
                ...  
            }       
        }
        catch (Exception ex)
        {
            ...
        }
        finally
        {
            insert.Close();
        }
    }

As result I receive Failure with message: To run an SSIS package outside SQL Server Data Tools, install Integration Services Standard Edition (64-bit) or later.

Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure

Error code: -1073679321
Description: To run an SSIS package outside SQL Server Data Tools, install Integration Services Standard Edition (64-bit) or later.

I think that need install something, but a don't know what.

Upvotes: 1

Views: 502

Answers (2)

Willimar
Willimar

Reputation: 71

Tanks Hadi, with your help I can resolve the problem. I would like complement your anwser.

To resolve the problem, I made folow:

  • Uninstall all SQLServer instances and tools. You don't need remove SQL Management Studio only all features from the SQL Server.
  • Uninstall MV C++ 2017
  • Install MV C++ 2015
  • Install SQL Server Developer. During instalation select Integration Service in features selections.

Don't forget reboot the operational system after uninstall process.

The SQL Server 2017 Setup result error whether you have the Microsoft Visual C++ 2017 installed in your Operational System.

The SQL 2017 needs of the MV C++ 2015. Because this you need remove the latest versions.

To check Integration Service status your need:

  • Open Services Manager of the Operational System and find name SQL Server Integration Services. The status from the service has be started.

To download from SQL Server use microsoft site [https://www.microsoft.com/pt-br/sql-server/sql-server-downloads]

Don't use SQL Server Express use Developer Edition. Also reade Hadi's Answer for more learning more.

Upvotes: 0

Hadi
Hadi

Reputation: 37313

From your question, it looks like you are using SQL Server Express Edition, if so you are not able to use SQL Server Integration Services since they are not supported in this edition. (It is only supported by Standard, Developer and Enterprise editions)

Also referring to the following documentation:

SSIS is not included with the Express edition of SQL Server.

You can try using Developer Edition instead since it is free.

Upvotes: 1

Related Questions