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

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?

Niceeee That worked perfect, I didn't even think of wirting it that way.

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?

do i get rid of the function setsubject()