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 |
|
mobasha
Starting Member
45 Posts |
 Posted - 2007-05-08 : 05:01:48
|
| hi alli have created a dts package and i want to know , is there any way to get the package script, and how??"like generating scripts for database objects"MobashA |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-05-08 : 07:48:17
|
| You can save it as a vb scriptor this will script the package http://www.nigelrivett.net/DTS/ScriptDTSProperties.html==========================================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. |
 |
|
|
mobasha
Starting Member
45 Posts |
Posted - 2007-05-08 : 07:57:40
|
| ok i can get the vb file, but how can i reload the file into sqlserver?? by the way am doing all this to get a dts packages which take the server and the database name and ather parameter(from a database table) and automatically create packages for each row in the table???MobashA |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-08 : 10:46:15
|
| You can open the file in em and save the package to sql server again. |
|
|
|
mobasha
Starting Member
45 Posts |
Posted - 2007-05-09 : 01:50:17
|
| ?????????? no i dont want to do it using GUI i wnat it code< buy the way if u save the fikle as vb the are same references u should add in the visual basic so u can run the file any way i may create my owne form which ask the user to supply some variables and create the apropriate packageMobashA |
|
|
|
|
|
|
generating dts packages script