Post reply

List Expressions and Values of Variables in SSIS package

  • 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

  • November 23, 2015 at 2:12 pm

    #1841862

    Thanks for the script.

  • 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?

  • 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.

Viewing 4 posts - 1 through 3 (of 3 total)

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