On quick observation, it seems to me DTS has a strange way to
interprete File System. ENV: NT OS, SQL Server 2000.
When a data import package (source point to c:\XYZdir) is executed at
EM level, sql server seems to think the "c:\XYZdir" is the current
user's "c:\XYZdir" , however, if the same package is scheduled as a job
and executed as a job, then, sql server seems to think the "c:\XYZdir"
is THE SQL SERVER INSTALLTION MACHINE's C:\XYZdir. It's quite
inconsistent. Please let me know your finding about this.
Also, I use ActiveX scripts to perform exception handing (error
checking) for certain transaction. For instance before a package
imports a file an ActiveX script checks source file's existence and
format, if not as expected halt here (not to execute the package).
Now, the two cases of (a) file not exist; and (b) incorrect file format
can't be determined by not running the package. Probably, the ActiveX
script should capture each case by creating a record/row during the
file checking. What's your thought?
TIA. 4 1255
It wouldn't suprise me. I've had similar findings with other aspects of
DTS. For example, we had differing versions of MDAC on the server and
my development PC. It was enough of a difference to stop our package
working (connection string differences). From what I understand, DTS
uses the local user's settings if you run it manually as it knows you
have run the package, but when you run it as a scheduled job, the
server is the one that calls the job (not a user) and it therefore uses
the settings, files and permissions of the server as it can't determine
which user's settings it 'should' be using, this makes sense for it to
run as the server. It is consistent though. UNC paths should work fine
if you can use these or re-look at the specifics of what you want to
achieve. There may be some helpful stuff on www.sqldts.com
HTH
Ryan
On 20 Dec 2004 13:42:58 -0800, NickName wrote: When a data import package (source point to c:\XYZdir) is executed at EM level, sql server seems to think the "c:\XYZdir" is the current user's "c:\XYZdir" , however, if the same package is scheduled as a job and executed as a job, then, sql server seems to think the "c:\XYZdir" is THE SQL SERVER INSTALLTION MACHINE's C:\XYZdir. It's quite inconsistent.
It's totally consistent. You give it an absolute path with a C: in it, it
uses an absolute path with a C: in it. When you execute immediately using
EM, the job is run using your credentials on your machine. When you
schedule it, it's run using the sql agent's credentials on the sql agent's
machine.
By way of analogy, if a .BAT file contained
FORMAT C:
would you expect it to always format the C drive of the person who wrote
it, no matter where the batch file was being run? Of course not. It would
format the local C: drive.
And actually l was using that after the conventional drive pointer's
negative experience. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: C. Barnes |
last post by:
Hi, I'm in the process of writing a Python linear
algebra module.
The current targeted interface is:
http://oregonstate.edu/~barnesc/temp/linalg/
The interface was originally based on Raymond
Hettinger's
Matfunc . However, it has evolved so that now it
|
by: David |
last post by:
Comments on a program called PHP Page Generator? (
http://www.phppagegenerator.com) I received a email offer of $100 and
the product appears to allow quick generation of code for SQL web
searches, reports, etc.
Thanks
|
by: Will Pittenger |
last post by:
I have a Windows program C# .NET solution where when I update its XML
documentation, some tags are not recognized and turned into the
corresponding HTML. Those tags include <c>, <code>, <para>, <paramref>, and
<exception>. <remarks> works; I have not tried <include>. Is this a bug in
Studio or am I using those tags incorrectly?
When the tag appears to have an attribute, I have tried
<paramref="parameter">paramter name</paramref> and...
|
by: Shiraz |
last post by:
Hi
I just made an installer package for an application in .NET which also uses
COM dlls. It seems to work fine on my machine but when tried it on a
co-worker's machine, the application installs, but while running, gives the
following error in the part that must use a certain COM dll:
COM object with CLSID {some hex code} is either not valid or not registered
I know which application is using this dll while the error is generated and
|
by: Mythran |
last post by:
I have asked this question here before but was given an answer I didn't like
(stubborn I am!). I believe the way my question was interpreted was not as I had
hoped...so I am trying again.
In C#, code commenting with Intellisense is used. In VB.Net, it's not. Fine,
dandy, but not what I am looking for. I just want to write the XML by hand and
use it in my library so it displays the intellisense itself, not through code
comments <--...
| |
by: Luke Matuszewski |
last post by:
Hi !
Simple question (but thus it may appear no simple answer):
If i putting a script onto the page i simply could inline it in
<script> element or via its src attribute so (second way):
<script type="text/javascript" src="js/crossBrowserDegradationLib.js">
</script>
, my question is simple
What encoding should i use when writting my
crossBrowserDegradationLib.js:
a) should it be the same encoding like encoding of my web page (and the
|
by: richard |
last post by:
So I wrote PyPI back a couple of years ago. It was just a simple cgi script
and some distutils code. I needed to call it *something* and "Python
Package Index" seemed like a fairly obvious name. Unfortunately, it's also
quite a mouthful. A friend suggested "PyPI" as a good shorter name. He also
indicated that it should be pronounced "Pippy" but that never really caught
on (just a little too cutesy for most people, I suppose).
...
|
by: I. Myself |
last post by:
This is about reading the .ini files which are used in several of our
projects.
Currently, the actual read of each line of the file is with this statement:
fscanf(file, "%s %s", name, value); /* reads two strings from .ini
file */
This works, but it does not allow any comments to the right of the two
strings.
|
by: Luciano A. Ferrer |
last post by:
Wich script package do you recommend me?
The goal is to build a site for news/articles, using categories,
with comments by users... and maybe a forum
I was thinking on xoops, but what about joomla for more power?
Can I have categories in joomla?
Any other suggestion?
TIA, and sorry for the bad english :)
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |