DSXchange

Hi,

I have a sequence job1, where I called uservariable activity to receive a value from execute command activity and pass it to one of the job activities.
I need the output of same uservariable activity to be used to sequence job2 as well. Is there anyway to be reused, instead of redesigning activities?

Unless sequence1 calls sequence2, the answer is no. And unless something has changed, there are no 'reusable' components in Sequence jobs other than routines... although I would think you could just cut-and-paste the User Variables stage from one job to the other. Depending on what "new sequence" means.

Thanks Craig
Yes, I may need to cut and paste the required user variable activities to new job.

You can copy/paste the User Variables activity to a new sequence; you'd also need to copy/paste the Execute Command activity. And each sequence would therefore run the command.