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

    DTS to Excel Calculation Problem

    Hi, You can use an ActiveX task in your DTS package and include the "RefreshAll" & "SAVE" methods for the Excel Spreadsheet. This will refresh the data in your Excel target. For example: Function Main() dim xlapp, xlbooks,xlsheet,SheetName set xlapp = createobject("Excel.Application") set...
  2. Kalpha7

    Batch Insert - delimiters, weird problem.

    Hi, Have you checked your source data for fields containing "DOUBLE QUOTES"?
  3. Kalpha7

    Permission problem running a DTS froma stored procedure

    I like the idea of a continuosly executing job that scans a user-defined table for the next actions to be performed. It's a very useful method that I've used on several occasions. The drawback with this method is that it circumvents secuirty completely. It is the equivalent of granting "SA"...

Part and Inventory Search

Back
Top