question

papakis avatar image
papakis asked

SSIS Variables defined on config file are not updated in runtime (legacy package deployment)

Hello
I'm using the legacy package deployment mode for a SSIS package that makes a very simple job : Copies on excel file from source location A to destination location B. This works as expected but when I'm trying to call the dtsx package from SQL server Agent's Jobs using a configuration file that contains different variables than those defined in design time this fails. The error message is

Started: 1:20:18 ?? Error: 2021-06-19 13:20:20.08 Code: 0xC002F304 Source: Copy Excel File System Task Description: An error occurred with the following error message: "Could not find file 'D:\Work\Excel\Source\SalesPersonsReport.xlsx'.".
End Error

I have used the CreateDeploymentUtility that exist on Project Properties as well as pointing to the configuration file during the creation of the SSIS execution step on SQL server job but without success

Regards
Nick

ssis2012configuration
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.