Package Scope Variables RRS feed

  • Question

  • Hi all,


    I created a Foreach loop container that picks up a number of text files and processes them.

    I created a Package scope variable called "Textfile" string 'U:\~ Strategic Sourcing and Value Analysis\SSIS\Nov_file'

    all runs good in BIDS, but when i try to execute it in sql agent it come back sucessful. once i check the file folder to see if all files have been processed nothing has been done.

    Wednesday, August 24, 2011 12:34 AM


  • HI,

    Use a UNC (e.g. \\MyServer\share) instead of the mapped drive path, also mare sure the account executing the package has the needed rights to access it.

    Arthur My Blog
    By: TwitterButtons.com
    • Proposed as answer by Todd McDermid Wednesday, August 24, 2011 3:02 PM
    • Marked as answer by Eileen Zhao Sunday, September 4, 2011 6:15 AM
    Wednesday, August 24, 2011 12:47 AM