Viewing 15 posts - 16 through 30 (of 101 total)
[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]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
August 11, 2010 at 4:11 am
[p]Good question. Thank you.[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
August 9, 2010 at 7:22 am
[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...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 22, 2010 at 8:11 am
[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]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 21, 2010 at 11:56 pm
[p]Hi srichaitya,
what error you are getting? what is your scenario? [/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 21, 2010 at 11:35 pm
[p]Yes, Elliott is right. You need to rewrite entire script.[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 21, 2010 at 11:27 pm
[p]Thanks for your response. It is working.[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 21, 2010 at 7:53 am
[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...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 21, 2010 at 5:22 am
[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...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 21, 2010 at 5:04 am
[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]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 21, 2010 at 3:59 am
[p]Create using Windows login and enable xp_cmdshell if required.[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 21, 2010 at 3:26 am
[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...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 21, 2010 at 3:18 am
[p]Delete there and now create the login and give mapping.[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 21, 2010 at 1:39 am
[p]Check whether the same login exist in that database under security->Users.[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 21, 2010 at 12:57 am
[p]Thank you for your reply Brandie, I am following your suggestions.[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 11, 2010 at 11:57 pm
Viewing 15 posts - 16 through 30 (of 101 total)