Re: setting DTS Global Variables

thanks for the reply darren
I would like to execute the DTS from the command line, that is use DTSRUN

I have something like this

dtsrun /SDC00675 /Usa /Ppwd3456 /NpkgImportText /ADatabaseName=Northwind3

so my global variable name is DatabaseName

now I want to change it to

dtsrun /SDC00675 /Usa /Ppwd3456 /NpkgImportText /ADatabaseName=Northwind2


but it's not working. I do not want to change the database object names
(since they will be the same) only the database names (within the same
server)





"Darren Green" <darren.green@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:e2MId4l2FHA.1276@xxxxxxxxxxxxxxxxxxxxxxx
> Leo wrote:
> > I have a Text File which I Import through a DTS package
> >
> > That is all fine and dandy, but what I would like to do is set the
> > destination of the file to a different server through code. So if I
specify
> > server X and database XX in code then the dts will dump the file there,
if i
> > specify server X (same server) and database YY (different database) it
will
> > dump the table there. Any ideas on how to do this?
> >
> > I have something that I created, where I have some code with two
variables
> > (server and database). In the DTS steps I execute that the first. Then
once
> > I set those variables, the second thing to execute is a dynamic
properties
> > task which takes the Server name and database name in the connection
from
> > its previous task (so from my variables). Then I have the actual
> > tranformation which happens. But the thing is even though the server and
> > database are properly changed in the SQL server, the transformation
doesn't
> > change, therefore it's still executing against the previous database
(not
> > against the one I defined in the variable)
> >
> > Any ideas? thanks
> >
> > Leo
> >
> >
> Changing the DataPump Source and Destination Tables
> (http://www.sqldts.com/default.aspx?213)
>
> --
> Darren Green
> http://www.sqldts.com
> http://www.sqlis.com


.

Relevant Pages

  • RE: DTS fails to import data when called from VB6
    ... have also installed MS Access on the server. ... Within the VB code I execute 2 DTS packages ... Note that if the DTS packages are executed manually on the ... >> I have created a DTS package that imports an Access ...
    (microsoft.public.sqlserver.dts)
  • Re: Static library works everywhere but server
    ... I installed sqlite database on FreeBSD. ... headers" 500 error. ... it works correctly on the server. ... execute the CGI, setting up the environment variables just as Apache ...
    (comp.unix.programmer)
  • Re: What commands can a user execute
    ... the query - yes, I'm aware of it - either at the Server or Database scope, no ... full list of SQL commands that a user can execute but, so far, it has not. ... mapped to any server roles but is a db_owner in almost all databases. ...
    (microsoft.public.sqlserver.security)
  • Re: Audit of sql server
    ... The DTS database transfer makes sense now. ... >> SQL Server will not check on this for you. ... >> Compiles each query but does not execute it. ...
    (microsoft.public.sqlserver.programming)
  • Re: Slow DTS Package on server-side
    ... DTS is a client application so DTS will look for resources in relation to ... package on the server then the package is no longer at the server it is at ... > schedule job in witch we execute about 100 dts packages. ... And if I connect to the server by enterprise manager and I start the> DTS package on the server from my PC, it takes 20 minutes. ...
    (microsoft.public.sqlserver.dts)