June 9, 2006 at 12:57 pm
June 10, 2006 at 12:30 pm
The package runs in whichever instance you're connected to when you open the package and execute it. The same is true for SQL Agent. The package will run on whichever instance the scheduled job is running.
Use this query to find the instance name:
select serverproperty('instancename')
Here's a good article: http://qa.sqlservercentral.com/columnists/tdavid/moreportabledtspackages.asp
Greg
Greg
June 12, 2006 at 10:56 am
June 12, 2006 at 1:35 pm
>>It's a vicious cycle.
Welcome to 1 of the major issues with DTS. You need to execute SQL to find your "current instance", but you can't execute SQL without a connection, and you can't dynamically point your connection without executing the SQL to find your instance.
Some of the workarounds:
- Dynamically configure via an INI file with a hard-coded location
- Run all your packages via xp_cmdshell running DTSRun.EXE and passing instance name via command line setting of DTS variables
June 12, 2006 at 1:50 pm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply