Re: Dynamic DTS Task Challenge

Hi,

dm4714 wrote:
My only opportunity now with the package is that the SQL Tasks has the
hardcoded name and SQL statement that includes the database name. Does anyone know of an easy way to change this information?

Can I also use an INI file for this? 
e.g. you can read the name from ini file and assign it to a global variable.
Then use an activeX task to replace placeholders in the sql statements with this database name.

Helge
.

Relevant Pages

  • Re: ADO data control
    ... Another way to test your query would be to try ... instinctively think that the database is probably not normalized. ... written on the topic of normalization, and one you might like is "Database ... Then the SQL statement and the existing WHERE and ORDER BY calculations ...
    (microsoft.public.vb.controls)
  • RE: FK Constraint Raised for no reason I can find?
    ... the constraints won't be copied to the destination database. ... But you could modify the sql statement for creating the table in the ... SQL Statement window above. ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.windowsforms.controls)
  • RE: FK Constraint Raised for no reason I can find?
    ... the constraints won't be copied to the destination database. ... But you could modify the sql statement for creating the table in the ... SQL Statement window above. ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.windowsforms.controls)
  • Re: Access having run time errors while selecting from odbc linked table
    ... Ok Frank, here ya go: ... Date and Load are variables that are collected by an input box so the sql statement can be dynamic in nature. ... >> Dim con As Object ... >> The exact same code sequence is used in the Database to select items from ...
    (microsoft.public.data.odbc)
  • Re: "Select" & "Order By" OK- WHERE Doesnt Work !
    ... some unspecified database system. ... add error capture code )') to your connect, ... show us the actual code including the echoed sql statement and error ... Tom Thackrey www.creative-light.com tom creative light com do NOT send email to jamesbutler@willglen.net ...
    (comp.lang.php)