0

There was no answer to Run SSIS package with project params from c# app can anyone help. Hoping someone might have an answer now. My case is I am just calling another package in a script task and pkg.Parameters["{Whatever}"].Value = ... works for package level parameters but fails for Project parameters, is there any way to achieve this? I kind of want to keep them as Project Parameters as they used in calling package as well and so then I can also test the called package in isolation.

I thought I could be smart to call pkg.Project.Parameters but pkg.Project is not of a useful type so you get an error "Cannot convert type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSProject100' to 'Microsoft.SqlServer.Dts.Runtime.Project'

Maybe I have download the Microsoft.SqlServer.DTSRuntimeWrap.dll version 11 and reference it in my script task for the cast to work!?

Glen
  • 802
  • 1
  • 11
  • 27

0 Answers0