Do I have it right that the originally deployed package fails in BIDS or in SQL agent, but it will still run successfully via dtexec? If so, are all...

I've attached a brief description paper that I put together last November based on the way I build my parent/child packages. I hope that it's useful.

There is also a...

Is it feasible in your environment to reconfigure package B so that its variables are parent package-configured from package A rather than as independent configuration file variables? This would...

Gaby Abed (5/29/2009)

Nothing wrong with upgradation, it's a perfectly cromulent word.

😀 (one hint...

Unfortunately, sunspot activity is currently inhibiting my psionic abilities, so I can't help the poster,...

Since the process is running between 2 different servers, I suggest that you run Activity Monitor while your process runs and see if you are getting IO or packet waits....

One way to get user variables into the column list is to use a derived column transformation above your lookup in the data flow, such as :

Derived Column Name: MyVar

Derived...

I found that by creating a role explicitly under the master database, rather than at the server level, that had execute assigned on xp_cmdshell, and assigning my user to the...

I have a B.S. in Geography with a minor in CS. My first job out of college was at a GIS mapping company. About 2 years in, they...

Grant Fritchey (5/1/2009)

You never know, but it just takes the right question or comment to spawn...

I saw it with my parents at the Meadows Center Cinema duplex in Terre Haute, IN, USA.

I was 6 years old.

It took a few days to get my jaw off...

Adding a parent package to a solution doesn't require re-writing packages to make them children packages. A new package, parent.dtsx, for example, can be added. This would consist...

Each package can read variables from multiple XML config files. Under the Package Configurations Organizer window, you can add a reference to each package to an XML file that...

My first inclination is that maybe you have an I/O bottleneck. When you monitor the process, are there any wait states indicated?

When I had to deal with a similar situation, I treated the numbers with characters as strings, and passed them through a script component that isolated the special character and...