Post reply

Prompt for connection details on installing the DTS job

  • September 15, 2004 at 4:42 am

    #60194

    Hi,

    The DTS package which I am creating will reside in the destination database. I do not know the source connection string.

    I heard that there is an option to save the uid and passwd used for DB connections WITHIN the DTS job – if you chose this option then when the DTS job is first installed these will be prompted for and once they’ve been entered and the DTS saved into the destination database they will not be required again.

    Please help...

  • September 16, 2004 at 9:39 am

    #523365

    See similar post at...

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=137244#bm137406

    Should be able to use for both source and password.

  • September 16, 2004 at 10:21 pm

    #523447

    Thanks for your reply. But the post says that the connection will be stored in a table.

    The client is not ready to give us the connection details in any form(INI file, Data file or UDL file)

    I need to get the connection details at the time of installation of the DTS package.

    I have an ActiveX Script task that uses  recordset to open up a table within a database.  To facilitate not having to go to my package and edit the connection strings, I want to set the connection string by taking the connection parameters set while installing the package(which will be prompted).

    When opening a recordset, how can I reference the recordsets connection properties to look at the connection string?  Is it even possible?

    Thanks again. Waiting for a reply sooonn..

  • September 17, 2004 at 8:42 am

    #523512

    When you say "during the installation of the package", what do you mean?

    Can you write the connection information to a table during installation after prompting, then refer back to this information to dynamically set the properties.  You might be able to add the information to a global variable to make things easier to reference in the package.

  • September 27, 2004 at 11:37 pm

    #524584

    Even I have no clue as to what my client means by saying "during the installation of the package".

    Anyways, thanks a lot for responding.

    I am getting the connection info from the user at the time of installation and setting the global variables.

    Thnx again.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply