Post reply

Why to use DTS instead of Import option

  • February 19, 2010 at 12:38 am

    #216937

    Hi

    All,

    I can convert access database to sql server database by going through imports option in the sql server.

    But if we can accomplish the task in this simple way what's the use of DTS or is there any extra features provided in the DTS.

    Also i wanna know what's the difference between DTS and SSIS.

    Anybody who knows the answer please post it.

    Thank u all

    Sachin

  • February 19, 2010 at 1:12 am

    #1121604

    1) Its better to design the package for daily import/export. Why? More reliable and easy to monitor and implement. Also during migration in same environment you can simple move your DTS.

    2) You will not see SSIS till you not install SQL 2005 or higher :-D:-D:-D. So forget SSIS if you still in the world of SQL 2000 and enjoying.

    SSIS is similar to DTS but with new features in 2005. Do google and you will get plenty of topics.

    Objective is same though :w00t::w00t::w00t:

    ----------
    Ashish

  • February 19, 2010 at 2:17 am

    This was removed by the editor as SPAM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply