Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SSIS and Import/Export (2008)  SSIS object variable is empty

Author  Topic  Riju Starting Member 1 Post Posted - 2014-09-29 : 15:13:29 Hi, I have created a package with one execute sql task to return the record-set(object variable) and used the object variable record-set in scrip task in same container(sequence, and its working fine). When tried to use the same record-set in another sequence container within the same package, only the column names is filled by data adapter(the row metadata values are not returned). I checked by using the data-flow task with record-set destination the result are same. is there anyway to use the same record-set across the package. Could someone help me in this. Thanks, Riju Thanks, Riju