Recent content by richrich05

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'...

Thanks all for the advise. I've started playing with open pgp and think that i'll use that for my PGP encryption needs.

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...

I wrote <%Response.Write(Request.ServerVariables("LOGON_USER"))%> and it returned a blank string my server allows for Anonymous Access to the sites on it.

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")%>" ~

Thanks that was very helpfully for me too.

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?

grrr i hate it when i forget simple things like adding coalesce else where in my statement.

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. "...

Well I'm trying to convert a date field called endtime from '6/10/2007 8:15 AM' and the starttime field into some kind of total of hours and minutes.

actually i do have some dates in my table as 1/1/1900 i figured i would use a else statment and show the column as a blank row.

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?