Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 run package as file system

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2010-10-26 : 09:25:00
i create
package that transfer data from DB1.table1 to DB2.table2
create enviorment variable on the servername .

create job(production server) on the file system.

when i run the job ,the job still run on the devlopment ,and nor no the production. (but when i save the package aas msdb ,it run fine on the production server)


webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-26 : 09:35:48
The package has info about connection inside.
I think if it is running from msdb then it is possible to change the connection by using environment variable else not.
But I don't really know that - it is just a guess.

But when you see the dtexec command in your jobstep then you can use /Conn <connectionstring> to point to produktion.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2010-10-26 : 09:49:31
the job (on the file system), do it run on the development server instead on the production server. (it ignore the variable system that i confige)
Go to Top of Page
   

- Advertisement -