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 RepliesHello 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
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
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 RelatedWhat 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.
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
Off of the MSDN SQL Server 2005 Enterprise Edition, what is the MSI I should use to install SQL Server 2005.
I have to Upload all files to a server, and this is going to be painfully slow. Can anyone tell me what the minimum is to upload and install SQL Server Enterprise (not Express)?
(For 32 and 64 bit non-Itanium machines)
Hi,
I have a client application that creates a COM object using the program ID 'SQLOLEDB enumerator' to get an ISourcesRowset. Once I retrieve the ISourcesRowset, I call ISourcesRowset.GetSourcesRowset to obtain a list of available servers.
This works if the client computer (the one running the application) also has SQL Server (or SQL Express) installed. But on a clean computer after installing SQLNCLI.MSI, the call to GetSourcesRowset returns an error 80004005.
My question is, what do I need to install on my client's machines so I can retrieve available servers using this method? Is there another MSI that needs to be installed? Do I need to install SQL Express Client_Components? Or is there something else?
Thanks in advance for any information you can provide.
-Eric Harmon
I do get the warning about Minimum Hardware Requirement, but can
find nothing in the detail requirements to exclude my PCs configuration.
I have installed:
IE 6.0 sp1
IIS as a part of Win 2000 Professional Edition SP4
I have also used ..aspnet_regiis -r to register ASP.NET 2.0
.NET Framework 2.0
SQL Server Native Client
SQL Server Setup support files
PC includes:
Pentium III 800 MHz
512 MB memory
HardDrive C: 5.92 GB (1.37 GB free)
HardDrive D: 13.1 GB (9.11 GB free)
I have tried several times to install SQL Server 2005 Developer Edition
(most recently from MSDN Disk 3097.1) I have tried to
complete an uninstall before each attempt.
I am, successfully, running Visual Studio 2005.
Any suggestions will be appreciated.
I am trying to upgrade the MSSQL Express with the Advanced Services version. I have:
Mobil Intel Pentium 4-M CPU 2.00 GHz
512 MB or RAM
50.8 GB free space on my C drive
I am getting the following message:
- Minimum Hardware Requirement (Warning)
Messages
Minimum Hardware Requirement
The current system does not meet the minimum hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online
I have looked at the requirements in the books and it seems that I meet or exceed the minimums.
Does anyone have an idea what I can do now?
Joseph McKown
I'm trying to call the SQL 2012 SSIS packages deployed in SSISDB from batch files from another client system. But I couldn't find the DTExec.exe file in the 110Binn folder. How can I install this utility? Can I get this utility with client installation or do I need to install Server components which need license. I donot have license to install server component. how to install the DTExec utility without any licensing and provide me the Setup link where I can download and install.
View 0 Replies View RelatedHi all,
I downloaded the SSEUtilSetup.EXE and extracted the SSEUtil.exe to a folder of C:drive of my PC that is Windows XP Pro. I plan to learn the CLR programming via user-instance of SQL Server Express. I need to have SQL Server Express Utility installed. Please help and tell me how I can install SSEUtil.exe in my PC and how I use it to interact with SQL Server Express.
Thanks,
Scott Chang
In my table I have values like (2,3). I want to get the minimum value from the column
View 12 Replies View RelatedWhat 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.
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
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,
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.
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
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 RelatedHi All,How do I set just enough permissions on a database so that a developer cancreate new objects and modify them without giving him administratorprivilege. At the moment the db objects are dbo and execute permissions aregranted to indevidual through a schema.GRANT EXECUTE ON [dbo].[My_Prcsedure] TO [MySchema]Thanks
View 2 Replies View Relatedi need to create a dynamic field, which returns the minimum value of 2 fields.
A B C(i need)
500 600 500
350 250 250
825 950 825
select A,B,min(A,B) as C from MyTable
i know this query is wrong,
pls help me to solve this problem
RGDS
BAHA
How can I find the minimum value of column?
Select salonuid, avg(LPPA),[Find the minimum](LPPA) from kpi.dbo.employee_data group by salonuid
The Yak Village Idiot
How to find the minimum value from time Timestamp column ?
I want get the eralier timestamp vlaues from the avaliable list
when iam using Aggregate transformation ..its again giving all the list of vlaues
Thanks
Niru
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
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
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
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
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
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
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
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
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
Hi,
I have a DTS named "Rahul_Test" where i have a global variale named "Rahul" INteher (1 Byte). N trying to assign this variable from SQL statement. Here is the syntax that I am writing.
exec master..xp_cmdshell 'DTSRUN -E -S142.102.27.222 -Usa -Psa -N"Rahul_Test" -ARahul:8="aaa"'
After executing the syntax I am getting the following message...
DTSRun: Loading...
DTSRun: Executing...
DTSRun: Package execution complete.
NULL
But the global variable "Rahul" doesnot get changed to 225.
Kindly help me out in this regard.
Thanks in advance.
Rahul Jha