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 |
|
Indian143
Starting Member
1 Post |
 Posted - 2007-04-18 : 02:33:41
|
| Hi All,I have created a DTS package by using SQL Server 2000 design wizard. And created transformation also by using design only. Its working fine taking the values from a ".csv" file to a table in "SQL-Server". Now I want to reset the connections for the DTS tranformations, so that it should take source and destination connections at runtime as user input values from a form. Can anybody help me how to achieve this task if possible give some code snippet. Thank you.Regards,Aleem.Mohd. Abdul Aleem,S/W Engineer,Lance Soft Technologies |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-04-18 : 02:54:26
|
| Have a look at the dynamic properties task.==========================================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. |
 |
|
|
|
|
|
Setting DTS connections at runtime