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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 DTS Question - TopSpeed

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
Go to Top of Page

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.
Go to Top of Page

hey001us
Posting Yak Master

185 Posts

Posted - 2008-09-10 : 16:42:51
May be this will help you:
http://social.msdn.microsoft.com/forums/en-US/vblanguage/thread/99c39c2b-0454-42f0-a346-42f4aacb9c18/

hey
Go to Top of Page
   

- Advertisement -