SSIS variabels

I have a variable which holds the path for an excel file.

I have set the value to work on my local machine.

When I deploy the package the hard coded value is no longer valid. I reset the value using a SQL Package Configuration table.

Is this the correct thing to, or should I map to a valid file path when deploying the package to the server?

Mr_ShawAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
jijeeshConnect With a Mentor Commented:
It is always good to have configurable. Whatever you are following is correct, though there are different configuration ways in SSIS. Such as .dtsxconfig file, sql pkg configuration.

 
0
 
Mr_ShawAuthor Commented:
thanks
0
All Courses

From novice to tech pro — start learning today.