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

    DTS Failing

    Pkailas, If the SQLSEVERAGENT is using the same log as my account shouldn't it still work? I tried doing a bulk insert in query analyser and using the mapped drive is still doen't recogonise it. It seems strange I thought there would be more maintenance using UNC.
  2. 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
  3. 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...
  4. namtab

    Batch File in DTS.

    I solved it. it was my .bat was wrong. Thansk for all the help guys at least I learnt about permissions.
  5. namtab

    Batch File in DTS.

    Im having a look at my permission at the moment. The only thing is I have set the agent to run under my account so I would imagine it has my security. I have loggen on the Server as myself so when I execute the package it works with my permissions and sqlagent has my Service Startup account yet...
  6. namtab

    Batch File in DTS.

    the event log gives the following message:- ************************************************************ The system cannot find the file specified. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSCreateProcessTask_1 DTSRun OnError: DTSStep_DTSCreateProcessTask_1, Error...
  7. 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?
  8. 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