x

SSIS 2016 Error: CPackage::LoadFromXML

My Environmet: Windows Server 2016 enu SQL Server 2016 Sp1 enu SQL Data Tools 2015 neu SSMS 16.5.3 enu VS 2017 neu

I have created a simple SSIS package (Send Email) with SQL Data Tools. The Package Format Version is 8. The Package is visible on SSMS Integration Services. This package can i deploying and excuting.

Problem: when I try to load the package in VS2017 Project on the same machine, then i get an error

The package failed to load due to error 0x80070002 "The system cannot find the file specified.". This occurs when CPackage::LoadFromXML fails.

demyPackage = r.LoadPackage("D:\Package_6.dtsx", Pevent) or
demyPackage = r.LoadFromSqlServer("MSDB\Package_6", ".", Nothing, Nothing, Pevent)

The Microsoft.SQLServer.ManagedDTS Version is 13.0.0.0 ; Fileversion:13.0.2164.0

I have already installed everything. I have no idea. Can someone help?

more ▼

asked Sep 27, 2017 at 11:38 AM in Default

avatar image

riedeld
1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

I can solve the Problem. In the Projects app.config file was a faulty entry.


     <assemblyIdentity name="Microsoft.SqlServer.Diagnostics.STrace" publicKeyToken="89845dcd8080cc91" culture="neutral"/>
     <bindingRedirect oldVersion="0.0.0.0-14.100.0.0" newVersion="14.100.0.0"/>   
 </dependentAssembly>**

i have deleted this and and it works

more ▼

answered Sep 27, 2017 at 12:05 PM

avatar image

riedeld
1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1231
x447
x35
x4

asked: Sep 27, 2017 at 11:38 AM

Seen: 108 times

Last Updated: Sep 27, 2017 at 12:05 PM

Copyright 2018 Redgate Software. Privacy Policy