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.
| Author |
Topic |
|
lols
Posting Yak Master
174 Posts |
 Posted - 2007-10-30 : 09:44:53
|
| Hi,I am executing a package using command line. I want to display messages on the console while the package execute. Which component will I use?thanks. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-30 : 10:00:23
|
| OSQL if you want to execute some SQL statementsKristen |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-30 : 10:01:45
|
| Sorry, under SQL 2005 the equivalent is now "sqlcmd" |
|
|
|
lols
Posting Yak Master
174 Posts |
Posted - 2007-10-30 : 10:50:29
|
| Thanks Kristen,Could you give me a small example as to which component do i use and how to call the sqlcmd from inside the package. |
|
|
|
lols
Posting Yak Master
174 Posts |
Posted - 2007-10-30 : 10:51:31
|
| I checked this sample, however it talks about storing commands in fileshttp://blogs.msdn.com/patrickgallucci/archive/2007/09/03/sqlcmd-and-the-power-of-the-little-r.aspx |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-30 : 11:31:25
|
| That's because you've found an article that talks about how to use scripts from files instead of the command line.Check the syntax at the top of that article, or look in Books Online for the help for that commandIn particular: [ -q "cmdline query" ] [ -Q "cmdline query" and exit ] Kristen |
|
|
|
lols
Posting Yak Master
174 Posts |
Posted - 2007-10-30 : 13:00:06
|
| ok i will try it |
|
|
|
|
|
|
Display command line messages