Please don't cross-post.

Please continue the discussion at:

http://www.sqlservercentral.com/Forums/Topic1079481-148-1.aspx

CEWII

Please don't cross post..

Please continue the discussion at:

http://www.sqlservercentral.com/Forums/Topic1079481-148-1.aspx

CEWII

I don't have anything with proxies but I have a fair amount of SQLCLR code for files. .Net framework 2 is all that is required..

CEWII

I think the SOX issue is overblown, without using encryption you simply can't keep someone who has administrative access to the server away from the database data. We can...

I'm curious about the requirement, why a batch file? Does it have to call it directly or just start a SQL Agent job? What is the real requirement?...

Parallelism was my guess as well, and would make sense if you had at least an 8 core machine. However, as far as you are concerned, it took 25...

Parallelism was my guess as well, and would make sense if you had at least an 8 core machine. However, as far as you are concerned, it took 25...

Lowell's method does work.. It violates my no xp_cmdshell rule..

I really think that if you must impersonate a different user then you might look at calling it from a...

I would probably do this in SSIS with a WMI query..

CEWII

I must agree, with the availability of SQLCLR the use of the OLE automation should basically never happen.. In other words don't enable them. Also as a practice...

I'm going to jump on the bandwagon and say DON'T! There are several ways to handle this and basically all of them are better..

Offering an idea I don't think...

My first thought was to prevent that one table from having duplicate data, or at least some process that controls which side is allowed to process its records.. I...

Why don't you control the process up front and assign records to servers which would guarantee that you don't have wasted effort. You have cases where each server is...

The easiest (as I understand your requirements) is to have a single package with 3 data-flows, one for each file. Or you could have 1 data-flow to handle all...

Could you elaborate on why it is the only way to get they key? Also, I just thought of an idea to better use hashes, perhaps hash it with...