While that may be true, much (most?) Open Source software can be used commercially at no cost....

You are on the rigt track.

You need a variable of type object. You use that object to hold the resultset from the execute SQL task. That object is...

I have to agree. A lot of stuff I write, I give away, not all of it, and the choice of which is which is MINE. I sell...

You could do it pretty easily in a for-each-loop. However, I would say to fully format all the data such as such as the body and the attachment name...

Extra pair of eyes...

You are very welcome.

CEWII

I think this is your problem

End If

Catch ex As Exception

...

So what does it return when it "errors"? It seems like you need to test for that.

CEWII

I just thought of something.

You need to have the command in the variable at design time so just put one in so the designer has something to work with.

CEWII

So does it cause an exception? If so if it causes a specific one you could use a try/catch block to handle he exception and keep going..

CEWII

xnl28-574517 (3/24/2010)

---

Hi, thanks for the suggestion. I tried it, but it also given an error, a different one. This one is:

The multi-part identifier "HouseFacilityGroup.HouseId" could not be bound.

Again, the revised...

What component are you trying to do this in?

Also a delete statement isn't going to have any columns to map to.

Perhaps you should tell us what you are trying to...

I have attached something I threw together that shows two different methods, the first takes the output from the WMI Data reader in a system.object and walks though it. ...

Most tools that do stuff like this drop the FKeys, insert the data and then re-add them.. Once you get enough tables involved, I'm thinking this isn't such a...

Then you have a bit of a problem. The job does not accept parameters. This leaves a couple different paths. You can use table based package configurations...

What WMI class are you using? I finally got a chance to really dig into this..

CEWII