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 TouchToneTommy 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: namtab
  • Content: Threads
  • Order by date
  1. namtab

    DTS Failing

    If I try import a file located on a network drive isH:\xxxx.txt, DTS fails that it cannot find the path specified. How ever if I have the full path name ie <server>\<directory>\xxxx.txt it works????? is there something im missing here
  2. namtab

    BCP

    I have the following code:- declare @cmd varchar(1000) set @cmd = 'BCP ' + '"Operating.dbo.Mobile"' + ' out ' + 'jingl1.txt' +' -c -S '+ @@servername + ' -Uxxx -Pxxx' exec master..xp_cmdshell @cmd which works fine however after reading BOL I tried putting a select Statement declare @cmd...
  3. namtab

    Batch File in DTS.

    I have a DTS package which executes a .bat If I execute the package it works fine but when I schedule it, it fails. All im doing in the .bat is renaming a text file and I have change directory to point to the correct location of the text file. Any ideas?
  4. namtab

    DTS vs BULK INSERT

    I have a Unix text file which has a fieldterminator of || and a rowterminator of LF. If I use DTS the import works perfectly however if I use BULK INSTERT i get :- Server: Msg 4863, Level 16, State 1, Line 1 Bulk insert data conversion error (truncation) for row 1, column 2 (c2). I know it's...

Part and Inventory Search

Back
Top