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 |
|
safecoder@gmail.com
Starting Member
22 Posts |
 Posted - 2005-08-08 : 08:31:20
|
| Hello -I need some help with the DTS packages...We have around 200 independent tables(Tables not related to each other) in SQL Server database and we have an Exact copy of the tables in DB2 database...The copy sitting in DB2 is exactly same inclusing datatype, field names etc...Now my question is..We have to copy data from SQL Server to DB2 every night and for that we need to write a Single DTS package for that...I first thought that we can just use the DTS tool, provide source, destination and select "Copy tables between databases" option and execute the package...But the syatem just hangsup after i hit next from "Copy tables between databases" and it never returns back..So, instead of using the DTS Tool, can we write a DTS package in some scripting file and execute the package? I never did that and it would be great if i can look @ some example...I searched a lot for DTS packages, but everywhere i found Tool based DTS packages..Instead, i'm looking for some scripted package, using ActiveX scripting or something like that....Thanks, |
|
|
|
|
|
Help with Writing DTS package..