DTSRUN Command Utility Problem

Jun 10, 2002

Hi everyone,

I have created a DTS package in SQL Server 2000 which is running good when I execute it through SQL Enterprise manager.

But when I try to run the package through command line DTSRUN utility on server, I am getting the following error message displayed.

"DTSRun: Loading...

DTSRun: Executing...

DTSRun OnStart: DTSStep_DTSDataPumpTask_1

DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)

Error string: Error opening datafile: There are currently no logon servers available to service the logon request.
Error source: Microsoft Data Transformation Services Flat File Rowset Provider
Help file: DTSFFile.hlp
Help context: 0
".

The same package is getting executed properly when I run it from my client through DTSRUN from the command prompt.

Any idea if it is because of security issues.

thanx in advance.

Mad

View 4 Replies


ADVERTISEMENT

DTSRUN Utility

Apr 9, 2001

Hello everyone,

I have a question about dtsrun hoping someone have an answer. Does anyone know if there is a switch that I can turn onoff so that it will suppress the output result when I execute the dtsrun ulitity?

This is what I ran:

master..xp_cmdshell 'dtsrun /Sclancy /E /N ExpDispute'

I get the following result back after it's done:

output
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DTSRun: Loading...DTSRun:Executing...DTSRun OnStart: Copy Data from Results to [Transplus_TestArchive].[dbo].[SG_DISPUTE] Step DTSRun OnProcess: Copy Data
from Results to [Transplus_TestArchive].[dbo].[SG_DISPUTE] Step; 14 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 14 DTSRun OnFinish: Copy Data from Results to [Transplus_TestArchive].[dbo].[SG_DISPUTE] Step DTSRun:
Package execution complete.
(6 row(s) affected)


Thank you in advance for any help.

Mai Nguyen

View 2 Replies View Related

DTSRun Utility

May 31, 1999

hi....

ok...all i want to do is take a global variable and pass it to another procedure using a wrapper... what am i missing...
if i call the 2nd procedure from the first it works fine.... but if i use the wrapper to call both procedures...and yes before you ask i am calling the first procedure that creates the variable before the second which uses it...

it doesn't see it... says it has no value...what am i missing.. please help...

kim

View 5 Replies View Related

DTSRun Utility Won't

Aug 18, 2005

I have been successful at setting up three or four DTS packages to runusing the DTSrun command line utility and the Windows scheduler untilnow. The latest package gives me the following error no matter what Itry.Error: -2147217355 (80041035); Provider Error: 0 (0)Error string: General error -2147217355 (80041035).Error source: Microsoft Data Transformation Services (DTS) PackageHelp file: sqldts80.hlpHelp context: 705I googled the error but got only two hits, only one of which actuallydiscussed the error. That one talked about the security and ID contextof the system agent but I can't even run the package from the commandline, never mind using the Windows chron. The DTS command line I'musing looks like this:DTSRun /S MyServerInstance /R DBName /N MyDTSPacakgeName /EVariations included /U MyUserName /P MyPassWord and a couple others.Next step would have been to use /!Y and /!C to create an encoded batchfile to use for the Windows scheduler.Any help would be most appreciated.Randy

View 4 Replies View Related

Minimum Install To Run DTSRUN.EXE Utility

Oct 27, 2000

What is the minimum installation on a user's PC to enable them to run a DTS package using the DTSRUN utility in a DOS bat file. The user currently does not have the mssql7inn directory on their PC. I don't want to install all of the components of SQL Server 7.0 on their PC, i.e., Query Analyzer, Enterprise Manager, etc. Does the server referenced in the DTSRUN command line need to be registered on their PC?

View 1 Replies View Related

What Are Support Files Necessary To Run Dtsrun Utility From VB?

Feb 1, 2000

What are the support files needed to run dtsrun.exe on a client machine which doesn't have enterprise manager loaded?

I found that dtsrun.rll is required along with dtsrun.exe. But something else
seems to be missing.

Has any body ever encounter this situation?

I am running the dtsrun utility from VB(the dts packages are in the form of COM structured storage files). When I install my VB program on the user's machine, dtsrun doesn't work because the user is not having enterprise manger on his machine.

Please help.

View 1 Replies View Related

Dtsrun Command!!!

Nov 27, 2000

Hi,
I am trying to run dtsrun command as a sheduled job and the user who executes that job is "sa".I am trying to import data from a Non-Secured Network to a Secured Network only port 1433 is opened.

The problem is that dtsrun is a OS based command and that runs in the context of the service which started the sql service and which is a RPC request.
I need to run a certain dts package at a sceduled intervals and i need a work around other than dtsrun..how can i do the same

replies will be greatlt appreciated
Jane

View 1 Replies View Related

Error When Running The DTSRUN Command

Nov 7, 2007

HiWe're using SqlServer 2000.I want to run a DTS using the DTSRUN command.The commmand is inside a ".bat" file which my application is runningfrom an SQL client.No matter how I run it from the client it fails giving me the message:[ConnectionOpen (Connect()).]SQL Server does not exist or access deniedI've tried to run it from the client from the application, from thecommand prompt and it fails.I went into enterprise on the client and tried to run the DTS fromthere. The run failed already on the 1st step which is a call to astored procedure, also giving me the same message. This really stuck meas wierd because in enterprise I'm accessing the server successfully sowhy the above messgae. It identifies the server and I am accessing it.Because it failed on the 1st step which is a call to a stored procedureI tried running the sp from within query analyzer and it succeeded.Has anyone got any idea what the problem is and ghow to solve it.Thanks !David Greenberg

View 1 Replies View Related

Dtsrun Works From Command Line, Not From Stored Proc

Jun 30, 2000

I need to execute a dts package from a stored procedure. I can call up the command prompt, enter the dts command, and it executes perfectly. Here is what I am attempting to do from the stored procecure:

EXEC master..xp_cmdshell 'dtsrun /S MyServer /E /N PackageTest'

On execution, the following error is returned:
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147217887 (80040E21)

Error string: Error opening datafile: Access is denied.

I would appreciate any assistance.

View 1 Replies View Related

Dtsrun Works From Command Prompt, But Hangs From Query Analyzer

Jul 17, 2006

I have a dts that works from the command prompt, but hangs in Query Analyzer.  Here's the code inside Query Analyzer:exec master..xp_cmdshell 'dtsrun /S BFHSQL4 /N vhl_dts_14144b /E'From the command prompt, it's just:dtsrun /S BFHSQL4 /N vhl_dts_14144b /EAny ideas what's wrong?  Thanks for your help!

View 3 Replies View Related

BCP Utility & Command Prompt

Dec 7, 2000

Can anyone tell me how to enable bcp utility. Because anytime I try to run BCP I get the following error messages: (BCP not enable). Also how can I get to SQL Server command prompt? I look forward to hearing from anyone.

View 2 Replies View Related

Dtexec Utility Command Line

Apr 23, 2008

Hi,
I need to run a package wich is located on the file system of a PC. The problem is that the PC from where I'm running a bat file to call the package from the other PC where the package is, doesn't have SSIS.
So I was wondering if this will work. I believe that I will have to copy the DTExec.exe file to the PC where my bat file calls to the dtsx in the other PC. I am right?
My run.bat will have this line: \PCshared_folderpackage.dtsx.
Will this work?
Thanks

View 6 Replies View Related

Tablediff Utility Without 'delete' Command.

Apr 23, 2008



I am presently using 'tablediff' utility of SQLServer 2005 to compare tables located on two different servers. My real intension is to backup data from Serv1 to Serv2, except that I wish to update the tables on server2 with only newly inserted rows and updated rows and NOT deleted rows.

In short, I want the final .sql file generated by the tablediff utility to contain only 'Insert' and 'Update' statements and NOT 'Delete' statements.

I hope someone can help me in this regard.

Thank you,
Little_Birdie.

View 6 Replies View Related

Unable To Run Command Prompt SQL Utility From SQL Agent

Mar 20, 2003

I am unable to execute DTS packages,ISQLs when scheduled from SQL Server Agent . It dispalys a Dr.Watson Access Voilation message on the box .The result of the job is "failed as the step did not return any result ".

1)The utilities run fine when run from clients from other computers .


2)They fail again when run thru the command prompt of the box .

3)They suceed when run via the xp_cmdshell .

Can anybody help me out ?

Thanks,
Venkat

View 7 Replies View Related

Option In Dtutil Command Line Utility

Aug 29, 2006

how can i create a folder in the integration services-stored packages-MSDB folder using dtutil command line utility.

I could create a folder within a folder inside MSDB using

dtutil /FC SQ; est;temp

but not in the MSDB folder.



Thanks &Regards,

Vivek S

View 1 Replies View Related

Running A SQL File From OSQL Command Line Utility

Jul 20, 2005

Hi,I have dumped a very large database from mysql (using mysqldump program)as a raw sql file. The reason was, convert this database to a MSSQLdatabase. Since mysqldump creates the file as raw sql file with thedatabase-table structures and the data in it, I thought using OSQL commandline utilities should work to out this whole database in MSSQL server.I have run this command from command line:osql -u sa -i mysqldump.sqlIt is going since yesterday. It has been almost 36 hours that it'sstarted. And in the mssql server, I see no database created yet. On thescreen of the command line, I see bunch of numbers are going in order. Iassume they are row numbers of the tables processed. But, if it is doing it,then where is it saving all this data ? I have checked the tempdb, pub db,other dbs, and I see no tables related to the database I am inserting. Willit populate it at the and of the job ? Or, am I doing something wrong here?Regards.Murtix.

View 2 Replies View Related

Using For Each Loop Container To Pass Parameters To Command Utility

Sep 1, 2006

Hello

I want to use a for each loop container to go through all files listed in a particular folder.
Each of those file names must be passed as a parameter to the relog.exe command utility

example:

Folder C: emp
Files in C: emp: log1.csv, log2.blg, log3.txt

The following lines must be executed:

c:
elog.exe c: emplog1.csv -f SQL -o "SQL:PerfCounters!PerfCounters"
c:
elog.exe c: emplog2.blg -f SQL -o "SQL:PerfCounters!PerfCounters"
c:
elog.exe c: emplog3.txt -f SQL -o "SQL:PerfCounters!PerfCounters"

The relog utility converts the performance counter logs to sql format and pumps it in the database (DSN:PerfCounters)

The idea is that someone drops multiple counter logs in c: emp and you start a SSIS package to pump the data from all the files in the database.

I'm not sure where to start. Do I have to put a Script task inside the For Each loop container en start scripting the commands in Visual Basic.Net or is there a more simpler way to achieve this in SSIS?

Many thanks!

Worf

View 3 Replies View Related

Solution: T-SQL Execution Command Line Utility Has Stopped Working

Jan 19, 2008

Reinstalling SQL Express did the trick

Thought this might help others..

View 2 Replies View Related

SAC Command Line Utility Doesn't Start SQLBrowser Service

Feb 16, 2007

I've exported surface area configuration settings from a server and tried importing them onto another server. The remote connection settings are imported but the SQLBrowser service remains Disabled. Am I doing something wrong?

The command line command I ran (in the C:Program FilesMicrosoft SQL Server90Shared directory) is "sac.exe in sacconfig.xml".

The following is my config file:

<?xml version="1.0" encoding="utf-8"?>
<CommandArguments xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Components>
<anyType xsi:type="Component">
<Type>SqlServer</Type>
<InternalType>DatabaseEngine</InternalType>
<Instances>
<anyType xsi:type="Instance">
<Name>SQLEXPRESS</Name>
<Service>
<Name>MSSQL$SQLEXPRESS</Name>
<StartMode>Auto</StartMode>
<ServiceState>Running</ServiceState>
</Service>
<Features>
<anyType xsi:type="Pair">
<Key>AdhocRemoteQueries</Key>
<Value xsi:type="xsd:int">0</Value>
</anyType>
<anyType xsi:type="Pair">
<Key>CLRIntegration</Key>
<Value xsi:type="xsd:int">0</Value>
</anyType>
<anyType xsi:type="Pair">
<Key>DedicatedAdministrator</Key>
<Value xsi:type="xsd:int">0</Value>
</anyType>
<anyType xsi:type="Pair">
<Key>DatabaseMail</Key>
<Value xsi:type="xsd:int">0</Value>
</anyType>
<anyType xsi:type="Pair">
<Key>HTTPAccess</Key>
<Value xsi:type="ArrayOfAnyType" />
</anyType>
<anyType xsi:type="Pair">
<Key>OLEAutomation</Key>
<Value xsi:type="xsd:int">0</Value>
</anyType>
<anyType xsi:type="Pair">
<Key>ServiceBroker</Key>
<Value xsi:type="ArrayOfAnyType" />
</anyType>
<anyType xsi:type="Pair">
<Key>SQLMail</Key>
<Value xsi:type="xsd:int">0</Value>
</anyType>
<anyType xsi:type="Pair">
<Key>WebAssistant</Key>
<Value xsi:type="xsd:int">0</Value>
</anyType>
<anyType xsi:type="Pair">
<Key>XP_cmdshell</Key>
<Value xsi:type="xsd:int">0</Value>
</anyType>
</Features>
<Protocol>
<anyType xsi:type="Pair">
<Key>NamedPipes</Key>
<Value xsi:type="xsd:boolean">true</Value>
</anyType>
<anyType xsi:type="Pair">
<Key>TCPIP</Key>
<Value xsi:type="xsd:boolean">true</Value>
</anyType>
</Protocol>
</anyType>
</Instances>
</anyType>
<anyType xsi:type="Component">
<Type>SqlBrowser</Type>
<InternalType>SqlBrowserService</InternalType>
<Service>
<Name>SQLBrowser</Name>
<StartMode>Auto</StartMode>
<ServiceState>Running</ServiceState>
</Service>
</anyType>
</Components>
<Version>9.0.242.0</Version>
</CommandArguments>

View 1 Replies View Related

DTSRUN......

Sep 5, 2001

What is the minimum SQL install required for dtsrun? Can I get away with copying a few files and not installing SQL.

Basically, the central SQL database has a DTS package which I need to enable a number of users to run. What I do not want to do is have to install SQL Server on all the end users computers.

ANy advice would be greatly appreciated.

View 1 Replies View Related

DTSRUN

Dec 7, 1999

We need to schedule a dtsrun batch to run on several servers at the same time. Can
someone tell me how to write this in my command prompt so it will run remotely.

We tried to run it locally but it does not work.

Thanks,
Dianne

View 1 Replies View Related

Dtsrun

Mar 11, 2003

Hi,

Question with DTSRUN
1) I have a batch file which runs a DTS package. Problem is after completion of the package the control doesn't return to command prompt. Any idea how to tackle this.

2) Even on the same server /U /P doesn't work. It errs out saying password is incorrect, Although I can connect to ISQL with same credentials.

Need to fix this asap.

Thanks,

View 4 Replies View Related

Need Dtsrun Help

Apr 13, 2006

I am trying to run two dts jobs using a batch file obviously using dtsrun but im having trouble. I've never attempted this before and it looked easy but not as easy as I thought.

I have two dts jobs, call them package1 and package2. I also saved these as .dts files. I made a .bat file and put it in the same location as the .dts files.

My batch file looks like this:


dtsrun /F package1
dtsrun /F package2
pause


This does not work and I get the following:

C:WINDOWS>dtsrun /F package1
DTSRun: Loading...

Error: -2147287038 (80030002); Provider Error: 0 (0)
Error string: The system cannot find the file specified.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 704

Can anyone help and tell me what I am doing wrong?

Thanks

Neil.

View 4 Replies View Related

DTSRUN

Feb 4, 2008

Hello all,
I am trying to run a DTS package from a .DAT file and in my file this is my code:

DTSRun /S ServerName /E /N "Promo Point Adjust - Import promo file"/
But when I run that the data in the table is not being updated. my question is
-how to I step through the to see what the disconnect is?
-Or if there is an error that is happening but being displayied?

Can anyone help me

View 1 Replies View Related

About Dtsrun

Nov 23, 2005

when I run the following in sql Analyzer :dtsrun /S"Local" /Ntestemail /UExternalRO /P"changmail"got this error:Server: Msg 170, Level 15, State 1, Line 1Line 1: Incorrect syntax near '/'.Is the command right?And how to run this dts package in commandline?Thanks

View 1 Replies View Related

DTSRun: Error

Mar 20, 2002

I have SQL Server 7.0 desktop installation and I installed SQL Server 2000 clinet.

Now, when I execute DTSRun from the command prompt, I am getting error message
dtsrun.exe Entry Point Not Found in dynamic link library SQLRESLD.dll

Can some one help on this.

Thanks

View 1 Replies View Related

DTSRun Error

Mar 20, 2001

Hello

I have created a very simple DTS package to transfer data from one database to another on the same server. I am able to successfully execute the package from DTS. But if i try to schedule the package and run it from SQL agent it fails. The job that is created by the SQL agent appears as follows -

'DTSRun /~Z0x2939C85E61C391613034D42DC85BA5E18B1E12D06DC31F 242542405E07594E436B58219AC124F29B80EDEB464ACB52BA 977BF7A0E59BE9C183507AF7CDA9EB1033C1E04009EC5D4467 E1955FB83FA31BC185F4D4398F51F008BDE6677D23F9C5571A 4C3010B0ED1943C234'

and the error message i get is invalid switch .... DTS command invalid options

Please help!

Thanks
aruna

View 1 Replies View Related

Dtsrun Error

Jul 31, 2001

Hello!
Here's a problem I'm having with user's laptop.
I installed SQL Server 7.0 client tools long time ago so she was able to use dtsrun utility.
Recently we moved our production database to the new server.
The difference between new server and old one is SP.
The old server had SP1 for MSSQL Server 7.0 and new server has SP2.

The DTS packages were copied from old server to new one and recreated accordingly.

Then when user was trying to run dtsrun utility she was getting error "Parameter is incorrect".
Then I applied SP2 to her SQL installation.
After that we've got different error message "Can not create COM server to load DTS package.
Class not registered".

I tried to register following files dtsffile.dll,dtspkg.dll,dtspump.dll,axscphst.dll using regsvr32 but I coudn't-I was getting errors.

Then I reinstall SQL client tools and applied SP2 again-still same error about COM server.

Any ideas what else can be done or changed to fix it?
Thank you

P.S.this user has another computer.
Applying SP2 to her SQL client installation fixed "Incorrect parameter" error and dtsrun works fine on this machine.


Lena

View 1 Replies View Related

DTS - DTSRUN Error

Jul 12, 2000

Hi,

Thanks for any help on this matter in advance.
I have a DTS Package that when I run from within the MMC it runs fine but when I schedule the job from the DTS design window or create a new job via SQL Agent and use dtsrun.exe with the correct parameters I get the following error:

DTSRun: Loading . . . Error -2147008511 (80074001) Provider Error: 0 (0)
Error String: Not implemented

Dts Owner is sa
Sa is also listed as owner for the job.
I tried changing the provider to ODBC for SQL Server since error message indicated a provider error and that did not work.
I searched Technet for 4001, provider error, dtsrun and got nothing relative. It would seem like a rights issue but SQL Agent Logs on as a local administrator for the SQL box which is also the PDC.

Any insight?


Thanks

Paul Kelly
like_dbaguy@hotmail.com

View 1 Replies View Related

DTSRun Erro

Jan 9, 2001

Hi everyone,

I am using SQL Server 2000 and I get this error.

I get the following error when I attempt to run DTSRun from the command prompt:


C:>DTSRun /S (local) /U sa /N "ACPAY_New" /R "ThedaCare1"
DTSRun: Loading...

Error: -2147217355 (80041035); Provider Error: 0 (0)
Error string: General error -2147217355 (80041035).
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 705

This error makes no sense to me. I also get the following message too

C:>DTSRun /S local /U rrojas /N ACPAY_New /R ThedaCare1
DTSRun: Loading...

Error: -2147217390 (80041012); Provider Error: 0 (0)
Error string: [Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionOpen (Connect()).
Error source:
Help file:
Help context: 0



What I have done is created a package called ACPAY_New and saved the package
in two places, the SQL Server and the Meta Data Services (Repository). The
name of the Database is ThedaCare1, the name of the server itself is local or rrojas, the user name is rrojas. I have no idea as to what this error message
means. If I run the job in SQL Server Agent, the job does not run at all.

If I run the package on it's own within Data Transformation Services, by
right clicking and execute it runs fine.

Please help.

Thanks,

Rey

View 1 Replies View Related

DTSrun.exe Is Not Working!

Jan 25, 2002

Hi Everybody,

I have created a DTS Package from SQL to Visual FoxPro(*.dbf). The DTS Package is working fine in Enterprise Manager. But when I tried to use 'dtsrun' by passing the servername, username,password and Package as parameters it is giving error.

The command which I tried in Query Analyzer as follows,

exec master..xp_cmdshell 'dtsrun /S DBser1 /U sa /P aaa /N pack1'

I am not able to execute the 'dts package' through
'dtsrun' utility. I am surprised that the same package is working fine Enterprise Manager without any error.

I tried all combination for FoxPro file by Creating Data Source Name throgh File DSN, System DSN and User DSN. All these alternatives are working fine in Enterprise Manager. But when I use 'dtsrun' utility it is giving all comibination of errors.

The following error I am getting when I execute through 'dtsrun.exe' utility,


DTSRun OnError: Delete from Table test Step,
Error = -2147467259 (80004005)
Error string: General error: Invalid file dsn 'C:Srims.dsn'
Error source: Microsoft OLE DB Provider for ODBC Drivers

OR

DTSRun OnError: Delete from Table test Step, Error = -2147467259 (80004005)
Error string: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error source: Microsoft OLE DB Provider for ODBC Drivers


Can anybody guide me how to execute through 'dtsrun' utility.

tks in advance,
Sam

View 5 Replies View Related

DTSRun: Error

Mar 20, 2002

I have SQL Server 7.0 desktop installation and I installed SQL Server 2000 clinet.

Now, when I execute DTSRun from the command prompt, I am getting error message
dtsrun.exe Entry Point Not Found in dynamic link library SQLRESLD.dll

Can some one help on this.

Thanks

View 1 Replies View Related

DTSRUN Batch Job

Aug 10, 2004

Hi all

I have a batchjob which runs a DTS package now it calls it ok
However it is running against 2 Databases on 2 servers and I get a login error even tho I am using the sa login

does anyone know of any issues relating to this Hopefully with a soloution that does not involve a lot of work

thanks

Michael Grieve

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved