Calling an SP from a DTS Package?

Wrox Programmer Forums

		Wrox Programmer Forums > SQL Server > SQL Server DTS
Calling an SP from a DTS Package?

SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

April 17th, 2007, 11:33 AM

Gibi

Gibi is offline

Registered User

Join Date: Jun 2003

Posts: 2

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Calling an SP from a DTS Package?

Is there any way I can call a Stored Procedure from a DTS package and manipulate the results like writing to a text file ?

I am using SqlServer 2000

Thanks,
Gibi

Old

April 18th, 2007, 05:47 AM

happygv

happygv is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 2,480

Thanks: 0

Thanked 1 Time in 1 Post

Default

If you are looking for exporting data into text file then you can try using BCP utility.

_________________________
- Vijay G
Strive for Perfection

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Classic ASP calling a SQL 2000 SP	jonsey	Classic ASP Databases	6	July 30th, 2007 04:03 PM
Execute DTS with input parameters from a SP	dbradley	SQL Server 2000	6	March 22nd, 2006 05:36 AM
Calling a DTS Package from VB	levinll	Pro VB Databases	0	November 7th, 2005 04:09 PM
Executing DTS package from ASP page via SP	savoym	Classic ASP Basics	0	April 28th, 2005 07:02 AM
Calling DTS package from VBA	tcarnahan	SQL Server DTS	2	October 13th, 2004 10:05 PM