Sorry..please if is possible, delete this topic.

Thanks,

Hi Jhon, best I going to describe the confirugation of my server, maybe there is some conflict with this. The service of SQL Server is charged by my domain user...

Hi Sugesh Kumar, I have the same error. What permissions have to have the user that execute a package with the follow statement for dont show error "Denied acces":

exec master.dbo.xp_cmdshell...

Thanks a lot da-zero! This is the solution!

Thanks SSC Veteran!

Dear, I want to execute a statement using xp_cmdshell using a variable of the package.

I am execute the package by SSIS.

My breakpoint is OnPostExecute from a task after the Execute SQL Task, and don't capture the value.

My optional solution was change the type from the column to nchar...but I follow...

I see the variablewhile is running using a breakpoint.

I has tried declaring the variable like Object, and don't capture the value.

Paul,

How I can vinculate a SQL Server account to Windows account?

Thanks by your help,

I has run test mail with rpp logged and this user have permissions in the drive.

Hi Peter:

->;Have you had a look at your mail profile and sent a test email?

Yes and was succesfull. And have anonymous authentication.

Please can you tell me how I can mapping a SQL Server login to Windows account? because I cant change the user 'rpp' for execute the SP.

Mohit, can you help me please? I want to delete this post.

I hope your instructions

Thanks to everybody!!!

Now I going to add a job that execute a delete scheduled

Hi, We are talking of a range of 3800 to 4000 records aprox in total.