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 |
|
nkonto
Starting Member
1 Post |
 Posted - 2014-11-06 : 06:46:32
|
| Hi, Is there a way to run a Dts package outside the server? maybe from Excel?nkonto |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-06 : 13:07:18
|
| Are you in SQL 2000? Then I suppose you can't do what you want.Starting with Sql 2005 you can use the SQLCMD command to run packages from anywhere. Note that the package probably still needs a database connection. However, it its just file to file or excel to excel, it should work.Curious though. What's your use case for running the package from Excel? |
 |
|
|
|
|
|
Run Dts Package Outside Server