Hi,

I figured out what the issue. I have a master package scheduled as a SQL server job.In the master package, there is a script task to attach the configuration file...

Hi Sabyasm,

Good point....

Jeff Moden (12/22/2009)

---

Heh... I probably wouldn't use SSIS for such a thing. I damned sure wouldn't use a script for this. T-SQL would do the job just...

That worked for me. I was able to figure out where I'm doing wrong.

Thanks,

Prasad

Jason Lees-299789 (12/22/2009)

---

Like Jeff, I'm not sure what it is you are trying to do.

what is the purpose of the package? Is it to parse through a list of files?,...

Hi,

I'm trying to use "ForEach From Variable" Enumerator. In the foreach loop, I'm able to read only the first item from the collection.

How can I access all the items in...

Thanks Bru and Phil. I appreciate your help. I will try that approach.

Phil Parkin (11/20/2009)

---

A single package will do the job for you. An EXECUTE SQL task can be used to run the sp's. Followed by one or more dataflow tasks to...