Cache Connection Manager- Value Can not be null error

hi all,

in 1 of ssis package using cache transformation , created cache file using cache connection manager. when moved package test environment showing error value cannot null. cache file path configured variable , variable have default value(eg: c:\a\b\c.caw , path not exist in test environment) run time variable getting updated correct value. sets delay validation true package raising on-error event.

could 1 please me.

thanks, anil

hi

there problem variable value debugging

i don't know logic for how finding path store files (it might in sql server directory)

if running job check path variable getting during run time exists in server.

if thats not case simple debugging in bids put msg box or breakpoint in script task.

---

please mark helpful if helps. sumit bi - integration services

SQL Server  >  SQL Server Integration Services