Styjun

Unpreventable damage to Gideon, the Oathsworn

Salesforce bug enabled "Modify All"

Are there historical examples of audiences drawn to a work that was "so bad it's good"?

Is a world with one country feeding everyone possible?

Why is this integration method not valid?

Is being an extrovert a necessary condition to be a manager?

How to test if argument is a single space?

Was murdering a slave illegal in American slavery, and if so, what punishments were given for it?

Must every right-inverse of a linear transformation be a linear transformation?

If a character has cast the Fly spell on themselves, can they "hand off" to the Levitate spell without interruption?

VHDL: Why is it hard to desgin a floating point unit in hardware?

Is it safe to redirect stdout and stderr to the same file without file descriptor copies?

Is there a word for pant sleeves?

What does it mean for something to be strictly less than epsilon for an arbitrary epsilon?

Existence of a model of ZFC in which the natural numbers are really the natural numbers

Passport queue length in UK in relation to arrival method

Which are the advantages/disadvantages of includestandalone?

Gas chromatography flame ionization detector (FID) - why hydrogen gas?

Coloring lines in a graph the same color if they are the same length

Singular Integration

What is the winged creature on the back of the Mordenkainen's Tome of Foes book?

Can the Conjure Barrage spell stack with the Disarming Attack or Trip Attack Battle Master maneuvers?

Shell builtin `printf` line limit?

What is the required burn to keep a satellite at a Lagrangian point?

Remote SSIS Management Visual Studio 2017 .Net Core 2.1.100-preview-007363

System.BadImageFormatException when running XUnit 2.2.0 unit test in VS 2017 against a full .net framework asp.net core projectUsing R.NET.Community in .NET Core 2.0 Preview 1The Exasol ADO.Net driver doesn't work with .NET CoreNUnit3.ConsoleRunner with .NET CoreProblems after install Net Core 2.0 building in Visual Studio 2015.net core website using full .net framework using sessionGetting XmlDocument to cooperate between .NET Core and .NET Frameworkreference .Net framework 4.5.2 from .Net Core 2.0 projectcan't run.net core 2.1 app on VS 2017 (15.7.5).NET Core 2.2 Assembly System.Windows.Forms missing

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

5

I am trying to start a SSIS package located on SqlServer. This code works in .net framework 4.5.2 but in dotnet core I get an error.

Code:

var sqlConnection = new SqlConnection("ConnectionString");
var ssis = new IntegrationServices(sqlConnection); // Error on this line of code
var catalog = ssis.Catalogs["CatalogName"];
var folder = catalog.Folders["FolderName"];
var project = folder.Projects["ProjectName"];
var package = project.Packages["PackageName"];

Error

Error CS7069 Reference to type 'SqlConnection' claims it is defined in 'System.Data', but it could not be found

Assemblies

Microsoft.SqlServer.Management.IntegrationServices.dll
Microsoft.SqlServer.Management.Sdk.Sfc.dll
Microsoft.SqlServer.Smo.dll
System.Data.SqlClient.dll // <-- Via nuget

I there something that I am missing?

c# sql-server ssis asp.net-core-2.0

share|improve this question

edited Mar 23 at 20:08

Hadi

25.7k73175

asked Feb 19 '18 at 0:55

Dblock247Dblock247

1,73742744

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  what version are you using? try to download the nuget again. nuget.org/packages/System.Data.SqlClient and get the latest version
  
  – Jeric Cruz
  Feb 19 '18 at 2:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @JericCruz I am using 4.4.2 which is the latest version right now.
  
  – Dblock247
  Feb 19 '18 at 13:40
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Dblock247 - did you ever get this working? I'm running into the same issue, tried various suggestions about packaging up assemblies as a local nuget, all to no avail. Would like to get this to work vs using SqlClient to use the EXEC [SSISDB].[catalog].* technique
  
  – CaseyR
  Mar 13 at 18:50
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @CaseyR No I never figured it out. I was for a test project so I didn't keep after the solution.
  
  – Dblock247
  Mar 14 at 16:55
  

  
  
  
  

add a comment | 

5

I am trying to start a SSIS package located on SqlServer. This code works in .net framework 4.5.2 but in dotnet core I get an error.

Code:

var sqlConnection = new SqlConnection("ConnectionString");
var ssis = new IntegrationServices(sqlConnection); // Error on this line of code
var catalog = ssis.Catalogs["CatalogName"];
var folder = catalog.Folders["FolderName"];
var project = folder.Projects["ProjectName"];
var package = project.Packages["PackageName"];

Error

Error CS7069 Reference to type 'SqlConnection' claims it is defined in 'System.Data', but it could not be found

Assemblies

Microsoft.SqlServer.Management.IntegrationServices.dll
Microsoft.SqlServer.Management.Sdk.Sfc.dll
Microsoft.SqlServer.Smo.dll
System.Data.SqlClient.dll // <-- Via nuget

I there something that I am missing?

c# sql-server ssis asp.net-core-2.0

share|improve this question

edited Mar 23 at 20:08

Hadi

25.7k73175

asked Feb 19 '18 at 0:55

Dblock247Dblock247

1,73742744

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  what version are you using? try to download the nuget again. nuget.org/packages/System.Data.SqlClient and get the latest version
  
  – Jeric Cruz
  Feb 19 '18 at 2:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @JericCruz I am using 4.4.2 which is the latest version right now.
  
  – Dblock247
  Feb 19 '18 at 13:40
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Dblock247 - did you ever get this working? I'm running into the same issue, tried various suggestions about packaging up assemblies as a local nuget, all to no avail. Would like to get this to work vs using SqlClient to use the EXEC [SSISDB].[catalog].* technique
  
  – CaseyR
  Mar 13 at 18:50
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @CaseyR No I never figured it out. I was for a test project so I didn't keep after the solution.
  
  – Dblock247
  Mar 14 at 16:55
  

  
  
  
  

add a comment | 

I am trying to start a SSIS package located on SqlServer. This code works in .net framework 4.5.2 but in dotnet core I get an error.

Code:

var sqlConnection = new SqlConnection("ConnectionString");
var ssis = new IntegrationServices(sqlConnection); // Error on this line of code
var catalog = ssis.Catalogs["CatalogName"];
var folder = catalog.Folders["FolderName"];
var project = folder.Projects["ProjectName"];
var package = project.Packages["PackageName"];

Error

Error CS7069 Reference to type 'SqlConnection' claims it is defined in 'System.Data', but it could not be found

Assemblies

Microsoft.SqlServer.Management.IntegrationServices.dll
Microsoft.SqlServer.Management.Sdk.Sfc.dll
Microsoft.SqlServer.Smo.dll
System.Data.SqlClient.dll // <-- Via nuget

I there something that I am missing?

c# sql-server ssis asp.net-core-2.0

share|improve this question

edited Mar 23 at 20:08

Hadi

25.7k73175

asked Feb 19 '18 at 0:55

Dblock247Dblock247

1,73742744

var sqlConnection = new SqlConnection("ConnectionString");
var ssis = new IntegrationServices(sqlConnection); // Error on this line of code
var catalog = ssis.Catalogs["CatalogName"];
var folder = catalog.Folders["FolderName"];
var project = folder.Projects["ProjectName"];
var package = project.Packages["PackageName"];

Microsoft.SqlServer.Management.IntegrationServices.dll
Microsoft.SqlServer.Management.Sdk.Sfc.dll
Microsoft.SqlServer.Smo.dll
System.Data.SqlClient.dll // <-- Via nuget

c# sql-server ssis asp.net-core-2.0

c# sql-server ssis asp.net-core-2.0

share|improve this question

edited Mar 23 at 20:08

Hadi

25.7k73175

asked Feb 19 '18 at 0:55

Dblock247Dblock247

1,73742744

share|improve this question

edited Mar 23 at 20:08

Hadi

25.7k73175

asked Feb 19 '18 at 0:55

Dblock247Dblock247

1,73742744

edited Mar 23 at 20:08

Hadi

25.7k73175

edited Mar 23 at 20:08

Hadi

25.7k73175

asked Feb 19 '18 at 0:55

Dblock247Dblock247

1,73742744

asked Feb 19 '18 at 0:55

Dblock247Dblock247

1,73742744