Search results for query: *

Hi I'm trying to build a DTS using SQL 2000 to import data from a informix server. installed and configured the driver on my sql2k server and was able to build my DTS but when i run it i get a error stating "[Informix][Informix ODBC Driver]Unable to load translation shared library (DLL)" anyone...

Hi I have accidentally dropped six key tables from my database and i'm trying to recover them from the transaction log. Whenever i use the following command in sql query analyzer. USE Master RESTORE LOG TSIT FROM DISK = 'D:\Databases\Microsoft SQL Server\TeamDB\Data\MSSQL\Data\TeamDB_Log.LDF'...

Hi All, I'm totally lost where to start. i need to start encrypting files sent daily to my supplier. I currently have a DTS that controls the creation and transfer of the file. How do i encrypt a file using SQL 2000 instances?

Anyone run into any problems downloading excel files through the FTP.exe process in a DTS? For some odd reason the excel files that i importing seem to show up corrupted. I use Execute Process task to run the script: Win32 process: ftp.exe Parameters: -i...

Does anyone know away i can pull the logged in username from a computer for a webform? this is what i did to pull from the cookie ~ <input type="text" name="EmailID" maxlength="10" size="10" Value="<%=Request.Cookies("NPSC")("UserName")%>" ~

Hi so i figured out how to FTP files using automated scripts but now i need to figure out how to send files with dates in there name eg. filename08-27-07.txt any one run into this challenge?

Hi i'm running into a weird issue when i add a coalesce function to my select statement. I'm getting a error that saids "Column 'NPSC_Reporting..TBL_SupplierInvoices.SI_InputDate' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. "...

I'm trying to to calculate two datetime fields into total minutes and hours. Anyone know a way to do this function? Something like (Starttime)(Endtime) = Totaltime

Does any one know a way to change a worksheet name in a DTS?

I'm trying to convert a varchar field into a money but I'm running into problems because the column contains some rows that are credits that have () around them. The expression I'm trying is listed below. Select cast(E_Amt As Money) AS Amount From Tbl_Expenses Oder by E_Amt Your help would...

I know this is simple but i've been beating my head into the walk trying remember and figure it out. How do i create a border around rows that are returned from the user's request?

Can anyone point me in the right direction? I want to display to the user the data their getting ready to submit to confirm if there sure or not prior to submitting. Anyone know a easy way to do it?

I need help i'm trying to control the subject of a email on a form using set text plus a drop down field value. function getsubject() { var Request = document.FrontPage_Form2.Request for (i=0; i < Request.length; i++) { if (Request.options[i].selected) { var...

I need help i'm trying to control the subject of a email on a form using set text plus a drop down field value. function getsubject() { var Request = document.FrontPage_Form2.Request for (i=0; i < Request.length; i++) { if (Request.options[i].selected) { var...

Is there anything out there better then procomm?

Does anyone know any good books to help with scripting for procomm? ~Rich~