CODEWITHSUNDEEP
asp.netssis
Anthony
Anthony

Reputation: 692

dtsConfig settings not applied when calling SSIS package from ASP.NET page?

I have an SSIS package with a .dtsConfig file. When I run the .dtsx package using the 'Execute Package Utility' then settings from the dtsConfig file get applied fine.

However, when I try and run the SSIS package from an ASP.NET page the settings in the dtsConfig file are not applied.

Anyone know why this may be?

Many thanks!

Anthony

Upvotes: 0

Views: 1102

Answers (1)

Anthony
Anthony

Reputation: 692

Thanks Faiz - I didn't realise you needed to tell the package from the codebehind the location and filename of the dtsConfig settings. I thought that because I told the package what the filename of the config file was when I was creating it that that would be sufficient.

I needed to add the following lines:

        myPackage.EnableConfigurations = True
        myPackage.ImportConfigurationFile(packageConfigPath)

Upvotes: 1

Related Questions