Griffster (2/22/2010)

---

So that would mean that the only way I could run the child package independently would be if I created another parent package that only calls the child package...

You do it in the Child Package, it is just like any other package configuration, the downside is you have to type in the variable name there isn't a...

You can do it with package configurations. Or you can adjust parameters at run-time. The best method depends on how you wil be calling the package.

CEWII

In the script you might look into:

Dts.Events.FireInformation

CEWII

I think Jack is right on. I was thinking about a parent package that conditionally calls the packages would be a better solution than a 40 step job. ...

Not to be abrasive but when I get told to do something that is questionable (in my view), I ask questions and try to figure out what we are trying...

You need to be careful reusing configuration files, if the file refers to an object that does not exist in BOTH packages then it throws an error (or might be...

You could use one of the open source zip libraries from codeplex and do it in a script component. GSquared had a good idea, my only issue is that...

We'll use this example, 10 files, 6 tables. Of those 10 files there are 3 that have the same structure and go into a table with the same structure....

I'm sorry to be a little short with you but you don't appear to be listening to what I'm saying.

The mapping you want to do CANNOT be done at run-time,...

Ok, I can't be any more clear on this.

Field mapping CANNOT be done at run-time. It doesn't matter what script you write.

CEWII

vithasun (2/19/2010)

---

hi CEWII

Thanks for the reply.

Textfile format is same(all are .txt files). Can it be possible using Script task/ script component mapping between each text file source and...

Are all the files/table the exact same structure? If not you have a problem. And you can't do this with a single data-flow.

The input schema and mapping of...

GSquared (2/18/2010)

---

I'd say the thing to do is look for companies hiring a junior DBA position. Trying to get a senior position in order to learn senior skills is...

How many files are we talking about? My main issue is that you have to set source structure, field mapping, and destination mapping at design time. What this...