Recent content by JefB

Thanks, I'll give it a try. JefB

I have a DTS set up that exports a SQL table to an Excel file. By itself it works fine, however I am trying to use a Global Variable to change the name of the '.xls' table. This is my code (in a stored procedure): exec master..xp_cmdshell 'DTSRUN /S ServName /E /N ENN_Var_DTS /A DstTbl:8 =...

Can I use host_name() in a DTS export path? I am trying to export the results of a query to the requestors PC. Thanks JefB

In an "Insert|Database|Result" (from a SQL2K stored proc)is there a way to control either the font color in a single cell or the cell backround color, based on the value in the field? For instance, in a daliy schedule, I would like the unused time slots (field value = "Open") to be a different...

Frankly, I do not remember exactly what I did to get this to work, but this is what I do now: (secure FTP already set up) 1) Use Export Wizard from selected database. 2) Select default values for Source 3) Select "Text File" for destination 4) Browse for destination path to previously set FTP...

I am using the Calendar Control 8.0 on one of my FrontPage .asp pages. When the page is displayed (in Internet Explorer), the Calendar is visible on some PC's but not displayable on others (just the small "x" box). Is there a setting in either FrontPage, IE or on the individual PC's that needs...

Related to the above: My SP works using a temp table (#tmpTLS) and I can display the data in QA but if I try using the temp table in a recordset in an .asp I get an error message saying that the object is not recognized. I start in an .asp that displays the data from #tmpTLS in a standard...

I have a DTS Local Package that imports data from an Access database table. DTS is in SQL2000 on an NT Server and the Access database is on a networked PC. The DTS package works fine if I set it off manually but fails if I set a scheduled execution. This is the fail message (in Job History)...

Instead of using a "text" data type, try "varchar(4000)". JefB

Thanks all. Now for the next part: How do I put this into a custom function? For instance; I want to return the value IN @FldName: CREATE PROCEDURE [dbo].[Eval_Test_Proc] @FldName text AS DECLARE @sql varchar(100) select @sql='Select ' + @FldName + ' from dbo.TeamEval_Data Where Status =...

Is it possible to feed a column name to a query as an argument in a procedure? My goal is a procedure to pull the value(s) from a single field, on the fly using the following code: CREATE PROCEDURE [dbo].[Eval_Test_Proc] @FldName text AS Select @FldName from (SELECT Evaluee...

Thanks JefB

We run SQL2000 on an NT box. According to my "hardware guy", we cannot do a direct tape backup of the server because "if we try to backup a database that is receiving data, the tape will hang up". This does not make sense to me, but more important, if this is true, how do...

I have a DTS Local Package that exports a query result as a ".txt" file to a secure ftp site. The package works perfectly. However, if I set up a scheduled job to run this, it fails. The history log says the following: >>Executed as user: SQL_SVR_U. ...Run OnStart: Copy Data from...

Either I am missing something or the fact that the data displays as an Excel spreadsheet within the browser window is what is causing this to not work; I get a spreadsheet without any data. The page that has the spreadsheet is "RoomsByDay.asp". That has the original code. I also set...