Matt Whitfield (9/22/2009)

---

Elliott W (9/22/2009)

---

VSS isn't terrible, but it isn't great either, especially if you have to pay for it. There are a lot of alternatives, all of my...

Matt Whitfield (9/22/2009)

---

Don't buy visual source safe, it blows chunks, badly. Really.

If you want a simple audit trail, write a CLR DDL trigger which scripts out the changed object and...

Also a good idea Erik!

CEWII

SQL_Quest-825434 (9/22/2009)

---

Hi,

Can you elaborate or give...

Just to make things clear, I did mean VB.NET within a Script Task (not a Script Component, nor a standalone exe) - to be run once per package execution, at...

Ok, here is a really quick and dirty POC. How many Dataflows run depends on the variable "ExecutionThreadCount", it can be up to 5. I even added some...

K. Brian Kelley (9/22/2009)

---

Use scripts or custom applications to do this, don't originate it from SQL Server (speaking as both a SQL Server DBA and a former directory services administrator)....

ganeshlohani (9/22/2009)

---

Thank you so much for your reply.

My case is

I am exporting rows from OrderHeader and Orderdetail tables into a text file to create the invoice. I...

Phil Parkin (9/22/2009)

---

An example of your input data would paint the picture much more completely than just words, no matter how detailed your verbal explanation ... So far I have...

John Rowan (9/22/2009)

---

I'm with you Elliot. Yes, you can thread multiple pumps inside a single data flow. Memory becomes the limiting factor. I typically use 1 pump...

stricknyn (9/22/2009)

---

Hi Elliott W,

I think your concept is close to what I'm looking to do. But the key pieces of the project are that I won't necessarily know is...

I'm not aware of any way to do it directly with SQL.

With that said, I do know of a way to do it with CLR (I think).

So if you are...

That is a good question, we had typcially handled...

John Rowan (9/21/2009)

---

It may be possible, but the only way I see it working would be for you to dynamically create data flow tasks based on your # of...

Phil Parkin (9/22/2009)

---

Or possibly (thinking a level up) a parent package that concurrently runs multiple occurrences of the same child package, with appropriate parameters.

I haven't tried that - and it...