Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

writing connection functions in activex script task within DTS

does anybody know whether i can write a simple connection string within DTS activex script task?

i have various function that uses the same connection. I find myself typing this a lot

 'Create and initialize (Open) ADO Connection
      Set objADOCnn = CreateObject("ADODB.Connection")
      objADOCnn.Open "PROVIDER=SQLOLEDB;SERVER=;UID=xxxPWD=xxx;DATABASE=fastpic2;"
1 Solution
Anthony PerkinsCommented:
You can, but I don't see the point (not to mention the security risk in having the password in clear text).  You are better off adding a SQL Server (Microsoft OLE DB Provider for SQL Server) Connection.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now