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 |
|
dupati1
Posting Yak Master
123 Posts |
 Posted - 2005-07-21 : 15:04:30
|
| Hello All,I am trying to tranfer data from Sybase DB to SQL SERVER 2000 DB. I know how to create DTS package to transfer data from one table on sybase to sql server 2000.Now i have to transfer around 10 tables...do i need to create 10 packages or can i transfer all these 10 tables at once...running serially one after another or parallel all at the same time in a single DTS package....if so how i do it...Thanks in advance |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-21 : 17:16:42
|
| You can do it. It's probably easiest to use the Import Data wizard that will create the DTS package for you. You'll end up with 10 parallel tasks, which you can make to run in series by creating 'on success' workflows between them. Or you can do it manually by:-Copying both your SQL Server and Sybase connection objects (just right click and Copy, then Paste to the workspace)-Creating a new Data Flow task between them. Probably best to do some reading up on DTS in BOL or do a search on DTS basics.HTH,Tim |
 |
|
|
|
|
|
simple DTS related question