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 |
|
rpc86
Posting Yak Master
200 Posts |
Posted - 2008-09-09 : 23:47:02
|
| Hi guys,Currently our company uses TopSpeed database for Clarion. I need to migrate data from TopSpeed to SQL Server 2000 using DTS. My question is how can I add conditions on the DTS. Say I only need to migrate particular dates "from" and "upto"Thank you |
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2008-09-10 : 00:43:33
|
| In "Execute SQL Task" object you can write your won SQL statement.hey |
 |
|
|
rpc86
Posting Yak Master
200 Posts |
Posted - 2008-09-10 : 01:30:05
|
| Ok, thanks for the reply. I'll make a try now.By the way, how will I run this DTS in VB.NET 2005 ? thanks. |
 |
|
|
hey001us
Posting Yak Master
185 Posts |
|
|
|
|
|