Create a dts package to produce a text file using the ‘update statistics&r

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

Question Posted / rajiv ranjan

1 Answers
1150 Views
I also Faced
E-Mail Answers

Create a dts package to produce a text file using the ‘update statistics’ command for th..

Answer / Rampal Singh

To create a DTS (Data Transformation Services) package that produces a text file using the 'UPDATE STATISTICS' command, follow these steps:

1. Create a new DTS package by selecting File > New > Package from the SQL Server Business Intelligence Studio menu.
2. Add Script Tasks for each table with obsolete statistics and write Transact-SQL code to update statistics for each table within the script tasks.
3. Configure a destination connection manager for generating a text file (such as Flat File Destination).
4. Add a Data Transformation task between the Script Task and the Destination Task, and configure it to pass the output from the Script Task to the Destination Task.
5. Save and execute the DTS package.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer