|
by: Ping |
last post by:
Hello,
Have a wonderful new year!
I have oracle 9.2 on XP.
There is a table T1 created by user U1 in U1's schema,
a synonym S1 created also by U1 to point to T1 in U1's schema,
U1 granted S1 to public for select.
|
by: m3ckon |
last post by:
Hi,
I'm writing a stored procedure to run a dts package and I've successfuly
got this working using my sotred proc and the syntax of dtsrun is
correct.
However, I'm trying to pass a variable to the DTSrun command and this is
where I'm having the problem
the code for the proc is:
|
by: José Joye |
last post by:
I know, this kind of question has already been asked. However, I could not
find an answer related to the minimal privilege required to be able to
create a new event Source in the appplication event log.
I have a service app that needs to access shares (therefore, I cannot not
start it using the System account). This service needs not to be...
|
by: Daniel Reber |
last post by:
I am trying to run a DTS package using C#. When I try to execute DTSRun it
runs hidden, I do not see the command window anywhere.
Here is my code:
System.Diagnostics.ProcessStartInfo info = new
System.Diagnostics.ProcessStartInfo();
//set up processstartinfo
|
by: Kevin |
last post by:
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 1
Line 1: Incorrect syntax near '/'.
Is the command right?And how to run this dts package in commandline?
Thanks
|
|
by: TaeHo Yoo |
last post by:
Hi all,
to run a DTS package you run dtsrun in the command prompt. It worked
fine. But how to run dtsrun in c# console application?
Thanks a lot
*** Sent via Developersdex http://www.developersdex.com ***
|
by: lawrence k |
last post by:
Okay, I just backed up my database, just in case.
The whole schema for the database is here:
http://www.accumulist.com/index.php?whatPage=db.php
You can run any SELECT query against this database that you want, and
send it as a GET request. This would be an example:
...
|
by: Brian Peasland |
last post by:
I am trying to get a DTS package to be run from the command line with
the dtsrun utility. The DTS package is stored in the database. The user
I supply is a user in the database. I get an error stating "SQL Server
does not exist or access denied." It looks to me like the SQL Server
instance does exist because it tries to start the package. I...
|
by: dutdut |
last post by:
Hello,
With MS SQL Server 2000, to run a DTS package called « test » through a stored proc, I use :
exec master..xp_cmdshell 'DTSRun /S (local) /E /N "test" /L "C:\Temp\log.txt"'
When I execute this command with the query analyser, it runs perfectly. But in the stored proc, it fails… :(
Actually, the dtsrun process appears in the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|