Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to add set values for package variable in Execute Package Utility Expand / Collapse
Posted Wednesday, June 12, 2013 1:46 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, January 25, 2016 10:47 AM
Points: 26, Visits: 302
I am execute package for test environment with new directory path and file name.
But when I am trying to set value for package variable giving me error below.

"DTExec: Could not set C:\Paychex\Paychex\Paychex\Paychex_ClockDataPackage.Variables[User::FilePath].Value value to C:\tlo\."

In package I am getting filepath dynamically from source side and loop through foreach loop container.
now need to change filepath for test environment without opening package from execute package utility.

and also attach screen shot file.

Please help me with this ..
I really appreciate your help....

  Post Attachments 
Error.png (3 views, 478.05 KB)
Package.png (2 views, 429.59 KB)
Post #1462807
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse