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)  Writing results of Stored Proc to text file

Author  Topic  Bugsy Starting Member 9 Posts Posted - 2006-10-03 : 16:51:46 Hey I have a stored procedure whose result i'd like to import into text file. I placed 'execute SQL task' that calls stored proc and text file (destination) connection. But when try to make 'transform data task' between them it fails. Any ideas will be apreciated.