Re: Msg Box and DTSRun

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 20:33:24 +0000

In message <eH4O8DTEEHA.3696@TK2MSFTNGP10.phx.gbl>, William Billington
<william_bill26@hotmail.com> writes
>Thanks for the reply, sorry I couldnt respond sooner. I am very new to
>this, so another question please.
>
>If within my package I have a global variable set to d:\import\stats\ -
>this being an actual drive on the Server which is SMCPROF1 (not mapped
>drive), would the package look in the right location ie on the server or
>would it be looking for that path on the local workstation.
>

Hopefully this has been covered by the other post.

>I thought using DTSRun would execute the package on the Server - if not, how
>do I set up my GV?

I just want to reiterate/clarify, DTS is a client side tool really. It
runs on the machine which you execute it from. To get it to run on the
server you must executed it on the server, such as through a SQL Server
Agent job. It also runs under the security context of the user who calls
the package, so from your desktop using Enterprise Manager or DTSRUN,
both of which are local to your machine, the package runs on your
machine, under your security account.

Cheers 

-- 
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Relevant Pages

  • Re: DTS Error EXCEPTION_ACCESS_VIOLATION
    ... >>We have some DTS jobs that runs every night called via a ... >>Package ... If this is no help, then please describe how you execute the package, ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: ETL rejects records intermittently
    ... The data source is the SQL SERVER 2005 table. ... We first dump the data from ... When I execute the SSIS package ...
    (microsoft.public.sqlserver.dts)
  • Re: which authentication mechanism should I use?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >execute rather than just assigning its sql statement and execute it later.I need the result in my Activex Script. ... > 'EXIT from function if there is another instance of the same package is running ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS and MSDE
    ... that does the calling of the package as the package runs from the place calling ... I will presume that the package is stored on a SQL Server somewhere. ... The above error is not appearing the in the vb app (removed error ... I've even used the "sa" login to execute the dts pkg and still ...
    (microsoft.public.sqlserver.dts)
  • Re: Export to Text File Fails from Server Box
    ... If you are on WKSTN1 and you pick up a package from SVR1 and press execute, ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... >I should have specified in my question that in re-creating the text> connection, I did point in to a file local to the SQL Server. ... When I click on the>>> Destination tab, there is an execute button. ...
    (microsoft.public.sqlserver.dts)