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 |
|
vinayj
Starting Member
32 Posts |
 Posted - 2005-06-30 : 23:01:07
|
| I'm new to DTS.The task that I want to do is that I want to run a SQL Script from DTS. I know that there is Execute SQL Task for the same purpose.But my problem is that the Script that i have to run will be in a file and I have to first read the file in DTS.then execute the contents of the file.The script file may contain :create database SOMEDBcreate table Table1 ( Col1 varchar(10), col2 int)I tried to use the DTS file handling but when i try to create a FileSystemObject it gives me the error that it cannot create FileSystemObject. And even if i am able to read the File using the FileSystemObject how would I run what I have read.Can you help me out. |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-07-01 : 00:43:04
|
| Try with osql. I think that would allow you to do this.Karunakaran___________It's better to be loved and lost, than ever to be loved... |
 |
|
|
vinayj
Starting Member
32 Posts |
Posted - 2005-07-01 : 15:36:06
|
| Thanks for the Idea. I have created a command file which consists of all the OSQL statements. And I'm executing the command file from the Execute Process Task. I need to pass parameters to the Execute Process Task dynamically. How can i do that.But thanx a lot for the tip |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-07-03 : 15:14:26
|
| Have a look at the dynamic properties task.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Running a Script in DTS