November 11, 2018 at 10:32 pm
I am trying to deploy an SSIS package using powershell commands.
$sqlConnectionString = "Data Source=MyMachineName;Initial Catalog=master;Integrated Security=SSPI;"# Load the IntegrationServices Assembly
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Management.IntegrationServices") | Out-Null;# Create a connection object based on the connection string
# This connection will be used to connect to the Integration services service
$sqlConnection = New-Object System.Data.SqlClient.SqlConnection $sqlConnectionString# Let's create a new Integration Services object based on the SSIS name space and
# the connection object created in the previous step
$integrationServices = New-Object "Microsoft.SqlServer.Management.IntegrationServices.IntegrationServices" $sqlConnection
However, I get a error: -New-Object : Could not load file or assembly 'Microsoft.SqlServer.Dmf.Common, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its
dependencies. The system cannot find the file specified.
At line:1 char:24
+ ... nServices = New-Object "Microsoft.SqlServer.Management.IntegrationSer ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [New-Object], FileNotFoundException
+ FullyQualifiedErrorId : System.IO.FileNotFoundException,Microsoft.PowerShell.Commands.NewObjectCommand
If I look at in my C:\Windows\assembly folder Microsoft.SqlServer.Management.IntegrationServices.IntegrationServices
is there for that version 13.0.0.0
Im using 2014 and trying to deploy my ispac file but not getting past this point.
November 27, 2018 at 10:58 am
llewellyn.egerton - Sunday, November 11, 2018 10:32 PMI am trying to deploy an SSIS package using powershell commands.
$sqlConnectionString = "Data Source=MyMachineName;Initial Catalog=master;Integrated Security=SSPI;"# Load the IntegrationServices Assembly
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Management.IntegrationServices") | Out-Null;# Create a connection object based on the connection string
# This connection will be used to connect to the Integration services service
$sqlConnection = New-Object System.Data.SqlClient.SqlConnection $sqlConnectionString# Let's create a new Integration Services object based on the SSIS name space and
# the connection object created in the previous step
$integrationServices = New-Object "Microsoft.SqlServer.Management.IntegrationServices.IntegrationServices" $sqlConnectionHowever, I get a error: -New-Object : Could not load file or assembly 'Microsoft.SqlServer.Dmf.Common, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its
dependencies. The system cannot find the file specified.
At line:1 char:24
+ ... nServices = New-Object "Microsoft.SqlServer.Management.IntegrationSer ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [New-Object], FileNotFoundException
+ FullyQualifiedErrorId : System.IO.FileNotFoundException,Microsoft.PowerShell.Commands.NewObjectCommandIf I look at in my C:\Windows\assembly folder Microsoft.SqlServer.Management.IntegrationServices.IntegrationServices
is there for that version 13.0.0.0
Im using 2014 and trying to deploy my ispac file but not getting past this point.
Looks like some file is missing as per the error. Suggest you post this error in SSIS forum, some one will be able to guide you better.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply