SQL query output to text file - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

SQL query output to text file

Author

Topic

gvkk
Starting Member

1 Post

Posted - 2008-10-06 : 06:11:45

Hi All,

I am new to tool , and i have a task to write sql query to a text file.

SELECT
Emp_SSN + REPLICATE(' ',9-Len(Emp_SSN)) +
Employee_Name + REPLICATE(' ',40-Len(Employee_Name)) +
FROM employee_tbl

i created Microsoft OLE connection for the employee_tbl , then text file destination , and in the transform of the line i do not know what to do .

If somebody can guide me where i can find the steps to do this it will be great help.

thanks
kiran kumar

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-06 : 06:42:02

just give a textfilename and make sure you map the fields to text file. Then click ok and execute it.

hanbingl
Aged Yak Warrior

652 Posts

Posted - 2008-10-06 : 17:26:28

and give it a column name too.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources