Remember the user machine has only SQL Express Engine and the packages are in SQL server 2005 machine.
Can any one help me out how to achive this scenario
Regards...
Executing SSIS packages from client machine using SQL Express Engine
I have few DTSX packages on my SQL server 2005. These packages are supposed to transfer data and stored procedures from server to client Express engine. The scenario is that when user connects with the server he should run some kind of utility or any other way to run those SSIS packages so that the data could be transfered.
Executing SSIS packages from client machine using SQL Express Engine
wfsCA
I am new to SQL server 2005 can you please guide me to some material or initial steps to create sql server agent job. And do i need to have some utility to give to client to run the agent job. won'nt dtexec command be used for it.
Also do i need to set the dynamic connection string for destination databases because there are more than one client using sql express engine.
Regards and thanx for the help
wd
In this case the packages would need to run on the server - a SQL Server Standard or Enterprise license is required to run SSIS. The only way to invoke a package remotely is to create a SQL Server Agent job on the server to run the package, and then invoke that Agent job from a client. The package will run on the server with the permissions of the proxy account used for the job.
Donald
pxgator
The documentation describes how to create an agent job. http://msdn2.microsoft.com/en-us/library/ms141701.aspx
Dynamic connection string are best managed using configurations. See http://msdn2.microsoft.com/en-us/library/ms141682(SQL.90).aspx
Donald
When using Books Online please remember that you can add comments (and vote) using the controls at the foot of the Books Online page - this will help us to improve the documentation for future use.