Hi,
I have a stored procedure where I am executing a dts package :
SET @cmdString ='dtsrun /S WEBSRV /E /N Load_textFile '
EXEC master..xp_cmdshell @cmdString,no_output
In this DTS package
1) Truncate existing Table
2) Load the text file in the table.
The problem is , when executed...
Thanks for the reply.
I want to schedule the job , and I don't want vb or any other exe to run on the server.
What I wnt to do is
-----
1) Open text file
2) pull out data from various tables by more than 1 queries
in loop.
3) write the data to file.
4) close the file
I can not divide the...
Hi,
I want to create a text file with a complicated format, so it will be very difficult by DTS. Can I open or create file from a stored procedure ? If yes , how ?
Please help.
Thanks
Hi,
I am trying to execute a stored procedure through VB application. If I run the stored procedure through Query Analyser , it takes around 1 min to complete.
As I was getting this error, I tried writing
con.ConnectionTimeout = 0
con.CommandTimeout = 0
But still its giving...
Hi,
I am trying to execute a stored procedure through VB application. If I run the stored procedure through Query Analyser , it takes around 1 min to complete.
As I was getting this error, I tried writing
con.ConnectionTimeout = 0
con.CommandTimeout = 0
But still its giving...
Hi,
I have set HTML Editor as frontpage.
But when I open IE6.0 , it gives me disabled EDIT option on toolbar. I don't know what the problem is.... may be registry ...
Can anybody tell me what may be the problem , and how to solve that ?
Thanks
Using javascript on clientside how to retrieve the value in a text box ?
For example ,
<asp:textbox id ="box1" />
box1 has value "ABC"
I want to get this "ABC" using javascript on clientside function.
Thanks
Hi ,
I want to use javascript for some simple client side validations, like if there are 2 textboexes, and if I write in second textbox, & first textbox is null , I want to give alert that first textbox value is null and the focus should be transfered to first textbox.
For this I need to...
Hi ,
I want to use javascript for some simple client side validations, like if there are 2 textboexes, and if I write in second textbox, & first textbox is null , I want to give alert that first textbox value is null and the focus should be transfered to first textbox.
For this I need to...
I have an ASP page , which requires a particular font.
I want to give users the facility to download the font from the site ......... How to do that ?
Is there any way , by which I can directly install the font on users machine ?
Thanks....
I tried ...... it is giving error as
document.order.qty is not an object.
Shall I write this code in a function , and call it from a vbscript Sub , where I am submitting the form ?
The problem is I am doing this kind of submit more than 3 times in my script. Each time depending on the text...
I have a form , where for some reason I am submiting it, with action = "<%=request.servervariables("script_name")%>"
i.e I am giving the self script name.
It is working just fine. But the problem is , after it submits , and returns back , I want to set the focus on a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.