I believe this to be a File System security issue but I can not get beyond it.

In my test I am using: XML, to call a stored proc which executes two .dtsx
packages. One DTSX package "CreateExcel.dtsx" creates an Excel File from a
Sql Table. The other dtsx package "RenameFile.dtsx" renames the Excel file.

This is my XML test url:
http://10.1.202.10/br_app_db/templat...ort_Number=PLA
This executes stored proc "sp_br_export_report"

When I execute the Stored Proc "sp_br_export_report" from a query window in
SS Management Studio, both DTSX packages run fine and all is well.

When I call "sp_br_export_report" from the XML, only CreateExcel.dtsx works
correctly. The result Excel file is never renamed.

I don't know how to get any debug messages when uing the XML call so I am
blindly trying many things.

This is a second attempt to "rename a file" . I had the same problem using a
xp_cmdshell. I setup the proxy account but still no luck.
@winCmd = 'rename file.xls newname.xls'
EXEC @shell_result = master..xp_cmdShell @winCmd

I gave up on xp_cmdshell and started the RenameFile.dtsx because the first
DTSX pacakge was working well. Now I am stuck again.

Any suggestions?

--
Peace,
Brian

If you can CREATE the file, then you shoule be able to RE-NAME it.

Have you tried putting a FileSystem Task in the first DTSX package to do the
re-naming?
--
Todd C

"briang" wrote:

If you can CREATE the file, then you shoule be able to RE-NAME it.

Have you tried putting a FileSystem Task in the first DTSX package to do the
re-naming?
--
Todd C

"briang" wrote:

If you can CREATE the file, then you shoule be able to RE-NAME it.

Have you tried putting a FileSystem Task in the first DTSX package to do the
re-naming?
--
Todd C

"briang" wrote:

If you can CREATE the file, then you shoule be able to RE-NAME it.

Have you tried putting a FileSystem Task in the first DTSX package to do the
re-naming?
--
Todd C

"briang" wrote:

If you can CREATE the file, then you shoule be able to RE-NAME it.

Have you tried putting a FileSystem Task in the first DTSX package to do the
re-naming?
--
Todd C

"briang" wrote:

If you can CREATE the file, then you shoule be able to RE-NAME it.

Have you tried putting a FileSystem Task in the first DTSX package to do the
re-naming?
--
Todd C

"briang" wrote:

If you can CREATE the file, then you shoule be able to RE-NAME it.

Have you tried putting a FileSystem Task in the first DTSX package to do the
re-naming?
--
Todd C

"briang" wrote:

If you can CREATE the file, then you shoule be able to RE-NAME it.

Have you tried putting a FileSystem Task in the first DTSX package to do the
re-naming?
--
Todd C

"briang" wrote:

I tried that but I will try again. I have gone thru so many reps, that I
have lost track.
--
Peace,
Brian



"Todd C" wrote: