Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Selecting server and database via Global Variables

Status
Not open for further replies.
WBH1138

WBH1138

Programmer
May 31, 2002
85
GB
I'm using a DTS package, saved as a Structured Storage File, which has 2 Global Variables to specify the Server and Database to run against.
From within VB I'm executing the package using the following Shell function;
Shell (dtsrun /NPackageName /FC:\Temp\DTSPackage.dts /AServerName:8="Server1" /ADatabaseName:8="Database1")

However, the package always runs against one specific server and database, whatever I pass in the Globals.

I've removed some references to this server and database which were in the Dynamic Properties, but could there be other references, set up when originally designed, that need to be removed?

 
Status
Not open for further replies.

Similar threads

petart
  • Locked
  • Question
Problem Date MS SQL Server
Replies
0
Views
158
petart
petart
ItHurtsWhenIThink
  • Locked
  • Question
Using Distinct and count in same query???
Replies
4
Views
191
gk53
gk53
okcorral
  • Locked
  • Question
insert in to DB2 Z/vse via SQL 2005 linked server
Replies
1
Views
168
okcorral
okcorral
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
147
botatun
botatun
johnb1023
  • Locked
  • Question
Date conversions between Microsoft SQL Server and Viewing in MS Access
Replies
0
Views
229
johnb1023
johnb1023

Part and Inventory Search

Sponsor

Back
Top