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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-02 : 11:02:12
|
| Kalyan writes "Can I execute a .dts file without sqlserver?I have a C# program which executes and stores data to a remote sql server from a local machine excel file." |
|
|
lizak
Starting Member
12 Posts |
Posted - 2005-08-02 : 12:13:44
|
| Yes.I don't have any experience calling DTS programatically from anything other than a SP but there seems to be a number of resources explaining how to do this.I've personally used the DTSRUN utility to execute DTS packages stored as files on disk. It's extremely easy to do. You can get this utility as part of the SQL Server tools from the SQL Server Install CD. You don't need to install SQL Server, just the tools. As a matter of fact you can use the utility on Windows operating systems that don't support SQL Server. |
 |
|
|
|
|
|
DTS