Using Data Transformation Services: How to Configure a Dynamic Property Task - Package Description

(Page 2 of 4 )

Let's create a new package, a simple one which copies the result of a query of the SQL 2000 server database to a text file at some location on the hard drive of the machine where the server is located.

First establish a connection to the Northwind database on your Server (please refer to previous tutorials to do this task). Then create a file on the C:\ drive and configure the destination connection as shown in this picture.

With these two connections made, add a Transform Data Task that uses the query shown below to copy the result of the query to the text file. Working with the Transform Data Task has been clearly described in more than one tutorial. This query can be pasted or can be created using the Query designer.

SELECT LastName, FirstName, HireDate, City, PostalCode
FROM Employees

If you were to run this package as shown now, 

you would see the following in the FileText.txt file.

 

Next: Run time modification of package >>
 

More Database Articles
More By Jayaram Krishnaswamy

Comments On: Using Data Transformation Services: How to Configure a Dynamic Property Task

· DTS's dynamic property task is one of the most useful tasks as it empowers you with...    · Hello Jayaram,I have a question on this subject. I currently have a DTS package...    · Can you be more sepcific as to what this package does? Are these 20 tasks inter...    · Hi,Basically I have SQL based web reports saved in 30 different sql files. Each...    · Send me some more info. Especially if you have screen shot of your package in the...    · Hi I have just started using the Dynamic Properties task and found it to be a...   >>> Post your comment now!