[p]Hi,[/p][p]I have come up with the solution for my post. I changed URL to http://<server>/ReportServer/reportservice2005.asmx. Please note this URL is case sensitive.[/p]

[p]Good question. Thank you.[/p]

[p]What I understood is, You are passing 2 parameters to a stored procedure using parameter mapping.[/p][p]First check whether the table "dbo.capture_Tracking" is available or not. I suspect this table.[/p][p]Instead of...

[p]Create an error log when using BCP utility. It may help you. I understand that you need increase the column size of your table.[/p]

[p]Hi srichaitya,

what error you are getting? what is your scenario? [/p]

[p]Yes, Elliott is right. You need to rewrite entire script.[/p]

[p]Thanks for your response. It is working.[/p]

[p]Don't use actvixscript task because it is going to be deprecated soon. You can use Script Task. You can write code in .NET or C#.. There are no global variable...

[p]Go to that particular DB ->Security->Users, delete the user login.[/p][p]Now go to Server name ->Security->Logins-> right click on the login -> properties -> map it to the database that you...

[p]You are welcome. [/p][p]Create credential using Windows admin login.[/p][p]I'm not sure about you scenario, so if you are running any operating system command, you can enable xp_cmdshell.[/p]

[p]Create using Windows login and enable xp_cmdshell if required.[/p]

[p]Actually, they are using SELECT @@SERVERNAME to get the server name and storing into a table. Then I am doing BCP OUT to flat file. Next doing BCP IN to...

[p]Delete there and now create the login and give mapping.[/p]

[p]Check whether the same login exist in that database under security->Users.[/p]

[p]Thank you for your reply Brandie, I am following your suggestions.[/p]