Rats! I thought I'd do the dtsconfig overwrite in the parent package as I need it continue and do more processing immediately after it had finished, I'd have to split...

wschampheleer (2/25/2010)

---

For the field in question in my data reader > input output properties > external columns, the datatype is already eight byte signed integer (DT_I8). Should I be converting...

wschampheleer (2/24/2010)

---

Looks...

If there is nothing to configure in the parent package, then you don't need a configuration file.

In sql agent jobs, you can have multiple steps. One of these steps can...

Sure, but you can even leave the copying of the config file out of the parent package and do it in you sql agent jobs (no need to pass variables...

wschampheleer (2/23/2010)

---

You're almost there too 😀

Copy either a.dtsconfig or b.dtsconfig to c.dtsconfig.

Make one minor change to x.dtsx to use the configuration in c.dtsconfig.

Running the package from saj1 or saj2 will...

wschampheleer (2/23/2010)

---

OK, I think I see where you are heading 🙂

You can dynamically change the connection used by the Execute Package Task using a variable in an expression (the exact...

Sorry Willem, I'm not made myself clear. Think I ought to show my steps...

1) I created a package, call it X.dtsx for example and set up an xml configuration file...

wschampheleer (2/22/2010)

---

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...

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 on...

Where do you set up the parent package variable in configuration files? In the child via BIDS or the parent?

wschampheleer (2/22/2010)

---

You can reuse the child's configuration file in the parent and then add extra configurations in the parent package (e.g. you can have more than 1 configuration file in...

wschampheleer (2/22/2010)

---

You can use package configurations in both the parent and the child package independently. The configurations for the child package should be defined in that package, not in the...

wschampheleer (2/22/2010)

---

I'm not sure I fully understand your question, but here's nonetheless a first attempt at answering it.

You are right that you will need an execute package task to run...

Koen Verbeeck (2/17/2010)

---

Griffster (2/17/2010)

---

An example is that it sees the time in Sybase (Sybase 11) table as 12:52:39.000, but SSIS sees the value as a DT_I8 with a value of...