DTS DataSource as Global Variable

Last Post 05 Jun 2003 10:52 AM by satya. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
DocX
New Member
New Member

--
05 Jun 2003 09:53 AM
Been trying for some time to no avail setting the Connection DataSource property to a global variable. Anyone know if this is possible? I'm trying to make the server name generic across all my DTS's for portability. When you execute DTSRUN you *have* to supply a server name but if the first step is a Set Dynamic Properties task shouldn't this then override the Connections.DataSource property? She ain't runnin with it for me Captain!

Thanks!

X!
satya
New Member
New Member

--
05 Jun 2003 10:52 AM
May refer this link and if not avail, then search for any tip.

HTH
You are not authorized to post a reply.

Acceptable Use Policy