Issues in DTS

Hi All,

i Want to use dts in vb.net.Can any one give me the solution to thus problem?

Can dts package store the data from the table ?

Rakesh

Hello. Are you referring to DTS in SQL Server 2000 or SSIS found in SQL Server 2005.

Either way, they are both applications/platforms for data movement, manipulation, work flow but they are not themselves storage applications. So you can use SSIS from SQL Sever 2005 to move an manipulate data from/to data sources (flat files, SQL tables) but SSIS itself does not store data.

I hope that helps.