Post reply

package config with xml file won't work? how to fix it?

  • October 30, 2011 at 9:16 pm

    #250216

    I have a user::variable in a package and want to stored it in an xml file, rather than specified when the package variable is define.

    there is no problem running the package with the value of the user::variable assigned and Save a copy of package to msdb to run as sql job. that value to User:variable stick.

    it wont work when the user:variable is changed to something else with the entire variable configuration at runtime is saved as an xml file with the sql job point to the xml file.

    i have even tried SET by SET Path element in the sql job for package and the package won't read in the value.

    how to fix this problem?

  • November 1, 2011 at 8:06 am

    #1401626

    After creating the xml config, try opening it with ie just to see if it is corrupt or valid... also in SSIS design mode assign the config to the package under SSIS > package configurations. also make sure what if the value being stored in the xml is data type compatible with the variable...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply