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 |
|
ServerTeam
Yak Posting Veteran
83 Posts |
 Posted - 2008-05-23 : 14:01:21
|
| HI Gurus,I am tring to add table to alraedy existing DTS pacakge to refresh data from other server.I dragged items from tool list (SQL SERVER Entripice manager)Ther ia m not able to connect those two icons(one source and other destination).How can i proced to next step.Thanks,ServerTeam |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-23 : 14:08:54
|
| When you say you aren't able to connect the two icons, do you mean you are getting an error? If so, posting it is always helpful. We can't see your environment nor can we read minds.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-23 : 14:10:39
|
| You've a task called transform data task on top menu under tasks. Select it and it will ask for source. Click on your source connection and then to destination. An arrow will appear connecting them. Now you can double click the arrow and modify the properties. |
|
|
|
ServerTeam
Yak Posting Veteran
83 Posts |
Posted - 2008-05-23 : 15:56:20
|
| Visakh you got my point and i am done with my issue..i mean its been solved by following u r reply..Thanks.Thanks,ServerTeam |
|
|
|
|
|
|
Modifying already existing DTS package