Re: setting DTS Global Variables

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • 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)