execute SSIS package in SQL Express environment

Dear all,

I have an SSIS package and want to execute it on a computer that only

has SQL Express installed on it. Since SQL Express didn't brought

dtexec or dtui so what should I do ?

Sorry for my bad English...

Thanks for advance,

SSIS is not contained in SQL Server express edition. You cannot run a package on box that only has the express edition. For more details on what is included on every version of the product see this:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||thanks for the reply..so there's nothing I can do ?|||

Sorry, I am a little bit confused. I am using SQL Server Developer Edition, which I believe is the same as SQL Server Express. Yesterday I was trying to find out how to do DTS in 2005 and found out on msdn that it had been renamed SQL Server Integration Services, and whilst I could not seem to start the SQL Server Import and Export Wizard via SQL Express as outlined in the knowledge base article, I could start it from the command line by running DTSWizard.exe manually as outlined in the article.

Or am I missing something?

|||Developers edition is not the same than Express edition; Developers edition includes SSIS.

Execute SSIS package from ".vbs" file

I need to execute a SSIS package from a ".vbs" file on a computer that don't have SSIS installed on it.

Thank You

The only way to remotely execute a SSIS package is to set up a SQL Server Agent job to run the package and run that remotely. If you can find a way of doing that in a .vbs file then you're laughing.

-Jamie

|||You can use ADO (from VBS) to call sp_start_job for an existing SQL Server Agent job, or even create a new job and then start. SSIS is not client/server as per SQL Server, it executes the package on the host machine. You need to use another technology to communicate wth the "server", hence the suggestion of using SQL Agent to host the process.

Execute SSIS package at remote server across domain

Hi,

Is that possible to execute SSIS packages from a remote SQL Server 2005 in another domain at local computer (Windows XP)?

Can I use SQL authentication to connect to the remote SSIS? My problem is, the user who execute the SSIS is not allow to access to SQL server directly. Is that possible to code everything in a batch file instead?

I tried to use web services to execute the remote SSIS but it always return "authentication error"?

Can someone help?

Many thanks!

Regards,

Mashmallow

Going via SQL Server is the simplest. Remote execution of batch files is not really viable,a nd will certainly have issues cross domain, unless you have a trust. I assume not hence the question.

The Books Online link below covers such the SQL Agentand Web Service method, including notes on getting security to work, have you seen it?

Loading and Running a Remote Package Programmatically
(http://msdn2.microsoft.com/en-us/library/ms403355(SQL.90).aspx)

|||

Thanks Darren.

I have seen this link before and I have tried doesn't work. When I try to debug, it say "Authentication error". Do I need to use Window Authentication or SQL Authentication.

I try to use the dtexecui utility from my local machine to call the package from remote server. However, It doesn't allow SQL authentication. I am currently using VPN to dial in to client network before I am able to run the SSIS.

Regarding the link that you have sent to me. I follow the same code and I get result as below:-

1) use window authentication - I get the "Authentication Error" when execute the code

2) use SQL authentication - I do not get error when execute the code but it doesn't trigger the SSIS execution at remote server.

Please help. Many thanks.

Regards,

Mashmallow

Execute sp_start_job from stored procedure

I need to disable and move orphaned computer objects in my Active Directory. The SQL Agent has permission to do this. I have created a stored procedure for the task with intentions of executing it with sp_start_job. However, I cannot execute it in SQL 2005. How can I grant permission to this (login) to execute sp_start_job? This is all run from a web page and NOT the Query Window.

The Agent is just a robot itmusthave correct permissions to run Jobs and other things replication included. So you clone admin level permissions to run it. Try the link below for SQL Server proxy account. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms190698.aspx