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!

  • Congratulations strongm 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: *

  1. RitchieBoy

    Janus Gridex - Updating Disconnected Recordset

    I have a janus Gridex on a form, and am populating it using a recordset for which i have set the Active connection to nothing (as i dont wont to update to the same place as i am retrieving the data). The problem i am having is that i want the users to be able to update some of the fields in the...
  2. RitchieBoy

    Bcp - Format Files

    No i didn't get it fixed, i have bcp working for both files coming in & out - but can't get the format file to work still !!. Still get the same error. If anyone has it working, if they could post a full example, that would be fantastic
  3. RitchieBoy

    DTS - Execute Process Task - Passing Parameters

    This is a DTS progamming problem !!! (using an ActiveX Script + AN Execute Process Task within a DTS) I am trying to create a DTS which accepts dynamic parameters for an Execute Process Task. Essientially i am running a stored procedure which among other things sets a global variable within a...
  4. RitchieBoy

    Bcp - Format Files

    I am trying to create a Format File for a bcp export procedure. The bcp command works without the format file, but when i try to use it using -f & the name and path of the file in the bcp string, it stops working. I get the error - 'Unable to open BCP host data file', does anyone know of why...
  5. RitchieBoy

    Can i Set the rowsource of a DTS from inside a stored procedure

    Can anyone tell me if it is possible to set the rowsource (SQL STATEMENT) dynamically from inside a stored procedure
  6. RitchieBoy

    Exporting data

    I have need the ability to output(export to a csv file) the contents of either a Hash table or a Table Variable from inside a STORED PROCEDURE. Does anyone know how to set the rowsource of a DTS dynamically from inside a stored procedure, or alternatively can anyone explain the bcp utility to...

Part and Inventory Search

Back
Top