It's ok. I solved the problem by avoiding it. Using SMO was an experiment and a bad idea for this problem. Wrong tool for the job.

Just used this last night. Fixed 4,500 naming violations. Wow. I had no idea people here were so bad at keeping up with our internal naming conventions....

Thanks for the data mining task tip.

I ended up being able to avoid SSIS, and not seeing any usefulness to SSIS.

I just did BULK INSERT with the filename, and no...

Thanks, that was very helpful (maybe I just needed a third person to say the same exact thing a different way).

The major reason column names and so on change is...

There is no forum dedicated to pure ETL questions, and this is the closest forum. I also think my questions are very closely related to SSIS, and as such this...

Sorry, I was fishing for an anecdote from you. Sort of like how somebody might say "I don't get normalization" and a million people on here could explain it...

CozyRoc (12/30/2010)

---

Have you seen Varigence's BIML product? You can generate complete SSIS packages using XML specification and you can also use .NET based scripting. If you are .NET -oriented developer...

I am an expert in object-relational mapping and have written my own proprietary OR Mapper used for financial services analysis,...

GSquared (12/29/2010)

---

I don't know what UI he's using for SSIS. BIDS doesn't have half the problems he complains about, and BIDS is the default environment for building these. ...

I don't think he is someone who likes to complain. He is considered a very good .NET developer*, but he is a developer. Ergo, my qualification earlier that...

Jeffrey Williams-493691 (12/11/2010)

---

Steve Jones - SSC Editor (12/11/2010)

---

I've used them, often as a base maintenance setup for systems that aren't stressed or critical. They have worked fine.

However when I need...

Yeah, it's okay. I don't enjoy when people ask me why X is taking so long when X is completely stupid and we shouldn't be doing X. Then...

gklundt (12/2/2010)

---

This works, but they cannot execute,...

If only everything uncommented between /* Begin Tirade */ and /* End Tirade */ was actually executable and could be run to subvert the Master Control Program[/url] and return the...

I don't trust Maintenace Plans.

For one, when you try to view the source code, the preview comes with a disclaimer that the source code might not actually be what gets...