That is such a good tidbit I have saved it for later use...

CEWII

I agree T-SQL would be A LOT faster.. What is the aversion to SELECT statements, in almost ALL cases they perform better than chosing the name off the list....

The fact that it turns yellow only means that it is running. The real question is whether the pipelines that are going INTO it and OUT of it are...

Jinx-640161 (5/12/2010)

---

You are right, it is using default values (doh!), a total misunderstanding on my part, for all I know I'm still not 'getting it'. So...

I leave the variables...

I am with the other posters, the person who suggested this must have their reasons. Perhaps they should list them out and generate a pros/cons list. And then...

I think this is a fundamental misunderstanding of dtsconfig files.

Config files can update properties of existing objects in a package, however, those properties have default values and if they didn't...

If I understand your requirement you want to run a process against 20 seperate database files. It is the same process for each and the only thing different is...

Ok then Steve, I can agree..

CEWII

eric_russell 13013 (5/4/2010)

---

I understand that you have hundreds of tables, and you want to "form relationships" between them. Could you describe in more detail what the objective is?

I'm thinking that...

I was just looking at that and I don't think I agree. For Custom SSIS tasks, like the components you have written they DO need t be placed there...

Actually,I kind of like that methodology..

CEWII

When you execute them from SQL Agent and you look at the job history, for the step detail what does the line in the step detail say following this:

Executed as...

steveb. (12/17/2008)

---

Pretty much what Jack said, a product like Informatica can cost tens of thousands of dollars wheras SSIS is free with sql 2005.

I was an Informatica developer...

I would venture to say that the packages contain passwords and that the user executing them is not the user who developed them.

CEWII

You are welcome.

CEWII