Maybe double up the \ so it is D:\\temp

CEWII

What does this EXE do? Does SQL run as a user or as localsystem (or equivalent).

CEWII

I'm not sure of a good way to work around this with the component itself, you could use a script component as a data source and read and format the...

You know Cozy, I recommend people look at your components quite a bit, I might need to download them and spend some time looking at them in greater detail myself..

CEWII

Off the top of my head you would have a data-flow component and within it two data sources and using a Merge Join component I would bring the two sources...

You can create one on the fly but it requires more steps than what I am going to recommend..

1. Create an empty mdb file with all the structures you need....

Sounds like a permissions problem. Run a trace on the SQL server and see if it is even getting logged in and starting the process.

CEWII

Can I ask why you want to use a file to accomplish this?

CEWII

I was unclear then.. I was talking about app structures like what you are taking actions on, there can and probably will be locking/blocking on these as each thread...

That advice is right on, and unfortunately not very obvious to the newer users in SSIS.

CEWII

I don't believe that checkbox exists...

That was my thought as well, I hate to be crotchety but why didn't he just google that? I really hate answering something that would only take 2 seconds...

First off, I have not actually done this. But I would think you would need a tool to read the inbox, and then take the message and strip the...

What version of SQL and 32 or 64 bit?

CEWII

I generally use the control structures to manage concurrency where I can, I only lock them long enough to get the work to do and mark that I have it....