List Expressions and Values of Variables in SSIS package

• waynef

  Old Hand

  Points: 364

  More actions

  October 19, 2015 at 1:17 pm

  #321928

  Comments posted to this topic are about the item List Expressions and Values of Variables in SSIS package

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  November 23, 2015 at 2:12 pm

  #1841862

  Thanks for the script.

• steven.taub

  Grasshopper

  Points: 13

  More actions

  December 29, 2015 at 5:10 pm

  #1848656

  Can't get it working. I tried it, and was unable to run it. Would it be possible to provide an example? For example, what if you package.dtsx is on the c:\temp folder, how do you adjust the script to work with it?

• waynef

  Old Hand

  Points: 364

  More actions

  December 29, 2015 at 6:30 pm

  #1848663

  Three aspects.

  1 - the script is developed for use with later versions of SSIS packages. Check the dtsx for the string packageformatversion - if it is 6 or earlier, the xml is different and the nodes sought in the Cross Apply won't work as shown.

  2 - the string <insert your target package here> in the script should be substituted with your target dtsx: e.g. c:\temp\mypackage.dtsx or \\server\share\pkgfile.dtsx because that's what the OpenRowSet command will work on. It treats that file as a single bulk load, so the filename and pathing has to be just so, or it will choke.

  3 - permissions - openrowset command may not be available to some logins. Use an administrator equivalent strength SQL account or AD user.

  Hope this assists.