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 |
|
neubie
Starting Member
21 Posts |
 Posted - 2008-12-03 : 23:10:20
|
| hi there,I have created file .dts. I thought this file as template so I don't need to select tables that I want to export/import.but, in that file, database source and destination have been set. yes I can change those database by go to PACKAGE|DISCONNECTED EDITbut, can we do by more simple way?thanks before |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2008-12-04 : 00:47:31
|
| When you say you want to select tables to export/import, are you referring to the Import/Export Wizard in Enterprise Manager? If so then there is no template for that, but you can save your DTS package and then reopen it and use it again and again in the DTS Package Editor. Also, once you have the package saved you can schedule it to run regularly without you having to open it at all. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-04 : 01:29:46
|
You can also make use of dynamic properties and pass the table name dynamically when executing the package.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
neubie
Starting Member
21 Posts |
Posted - 2008-12-04 : 01:57:47
|
| for snsqlyes, I refer to import/export wizard. I have saved to file about its configuration. but name for databases (both source and destination) are static.@pesodo u mean I can change database name for source and destination when I run the file (.dts)? then how?thanks |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2008-12-04 : 20:57:48
|
| Take a look at the execution tools herehttp://msdn.microsoft.com/en-us/library/aa176402(SQL.80).aspx |
|
|
|
neubie
Starting Member
21 Posts |
Posted - 2008-12-09 : 03:34:41
|
| sorry, if I correct, there is no option to set data and log file in dtsrun (via command line)correct me please...thanks |
|
|
|
|
|
|
ask - can I change database in .dts file?