Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why Don We Include the Data Transformation Task and the Data Driven Query Task with DTS?

April 26, 2017Data driven DTS query Task Transformation

0

Posted

Why Don We Include the Data Transformation Task and the Data Driven Query Task with DTS?

1 Answer

0

Posted

SQL Server 2005 includes the Data Flow task in place of these two SQL 2000 tasks. The Data Flow task places no limits on the number of sources, destinations and transforms, unlike in SQL 2000 where the user was limited to a singe source, destination, and transform per task. The new object model required to support this expanded functionality could not accommodate these two less robust tasks.