file upload and DTS between servers

[CFDaddio]

Hello. I have two servers (A and B) in our environment. 'A' hosts sites and
runs CF. 'B' acts as a dedicated SQL Server box.

I'm trying to allow client to upload a file in their admin area (on 'A') and
have a DTS package on 'B' run a bulk import from that file. I think I'm
running into permissions issues that's not allowing it to happen. If I run the
DTS package while logged onto the 'B' box, it runs fine.

But, when CF page on 'A' invokes a stored procedure on 'B' (that in turns runs
the DTS package), the DTS package will not run. Is this a function of CF, of
SQL Server, or of the Windows permissions?

Thanks.

Matt

[adonis1976]

While you created DSN in CF admin on server A, the user you chose should have
permission to execute the stored procedure on the DB on B. If you ask me I
would choose the same user who is the owner of Database on B while creating DSN
on CF admin on A.