dbTalk Databases Forums  

Is there a way in SQL Server 2005/2008 to run a solution from a command line?

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Is there a way in SQL Server 2005/2008 to run a solution from a command line? in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Hoardling1 via SQLMonster.com
 
Posts: n/a

Default Is there a way in SQL Server 2005/2008 to run a solution from a command line? - 08-24-2009 , 04:04 PM






Running SQL Server 2008.
Just wanting to know if there is a way to run a project/solution from the
command line.
I know I could put some of the solutions in a stored procedure and then run
from command line, but I don't want to split my solution up and some of the
solutions are universal, they handle SQL Server or work with multiple
databases.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...tools/200908/1

Reply With Quote
  #2  
Old   
Moby
 
Posts: n/a

Default Re: Is there a way in SQL Server 2005/2008 to run a solution from acommand line? - 08-25-2009 , 07:27 AM






dtexec

it works either on files (*.dtsx) or on packages within the
Integration Services

you can generate the commandline by:
make a double-click on the dtsx file an switch over to "Command Line"

kr moby

Reply With Quote
  #3  
Old   
Hoardling1 via SQLMonster.com
 
Posts: n/a

Default Re: Is there a way in SQL Server 2005/2008 to run a solution from acommand line? - 08-25-2009 , 12:23 PM



Ok, I will try it soon.

Thank You
Moby wrote:
Quote:
dtexec

it works either on files (*.dtsx) or on packages within the
Integration Services

you can generate the commandline by:
make a double-click on the dtsx file an switch over to "Command Line"

kr moby
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...tools/200908/1

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.