Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JefB
  • Order by date
  1. JefB

    DTS Global Variable for Export to Excel

    Thanks, I'll give it a try. JefB
  2. JefB

    DTS Global Variable for Export to Excel

    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 =...
  3. JefB

    Using host_name() in export path

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

    Font or Cell Color by Value

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

    SQL Job Agent

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

    Calendar not visible

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

    Table Datatype vs local and global temp tables

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

    Scheduled DTS failure

    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)...
  9. JefB

    DTS Truncating when transforming data from Access to SQL

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

    Using a variable for a column name

    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 =...
  11. JefB

    Using a variable for a column name

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

    SQL2000 Backups

    Thanks JefB
  13. JefB

    SQL2000 Backups

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

    SQL Job Agent

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

    I use the following code to display

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

    I use the following code to display

    How do I feed the values to '" & startDate &"', '" & endDate & "'? JefB
  17. JefB

    I use the following code to display

    I use the following code to display data from a SQL2000 database in a spreadsheet as an &quot;.asp&quot; page. <%@ Language=VBScript %> <% 'Change HTML header to specify Excel's MIME content type Response.Buffer = TRUE Response.ContentType = &quot;application/vnd.ms-excel&quot; %>...
  18. JefB

    Training Suggestions

    Unfortunately, we do not have enough staff needing training to warrant bringing a trainer on site; there are just 2 of us needing training. That is why I'd prefer a public class somewhere in the Chicago area. Thanks for trying. JefB
  19. JefB

    Training Suggestions

    Due to an upgrade by one of our software vendors, we need to get up and running on Crystal Reports (linked to an Access database and later to an SQL2000 database). If allowed, can I get some recommendations for Crystal Report training in the Chicagoland area? Thanks JefB
  20. JefB

    FrontPage Data Result to Excel

    I have tried using that code (along with: <%Response.Buffer = True%>, <%Response.Clear%> and ending with <%Response.End%>) All I get is the spreadsheet with the &quot;FrontPage Components&quot;; no data. I suspect that our system (SQL2K running on NT4) is missing a setting or something. Our...

Part and Inventory Search

Back
Top