DTS Query

Wrox Programmer Forums

		Wrox Programmer Forums > SQL Server > SQL Server DTS
DTS Query

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 18th, 2005, 11:39 PM

smujib

smujib is offline

Authorized User

Join Date: Feb 2005

Posts: 21

Thanks: 0

Thanked 0 Times in 0 Posts

Default

DTS Query

Hi,
How can I run multiple queries in a DTS package, it allows me only one query per package.

Thanks

Old

April 19th, 2005, 03:35 PM

bmains

bmains is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 1,998

Thanks: 0

Thanked 3 Times in 3 Posts

Default

You should be able to run multiple queries through ExecuteSQL tasks, and even multiple queries per task. What are you trying to do?

Brian

Old

April 19th, 2005, 03:36 PM

jbenson001 jbenson001 is offline

jbenson001 is offline

Friend of Wrox

Join Date: Nov 2003

Posts: 1,348

Thanks: 0

Thanked 5 Times in 5 Posts

Default

You can have multiple Data Transformation tasks and specify SQL command in each one. OR just use multiple Execute SQL Tasks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Output Query to txt file from SQL Query	everest	SQL Server 2005	4	November 22nd, 2007 01:49 AM
DTS Import/Export wizard query	Neal	SQL Server 2000	0	April 3rd, 2007 10:19 AM
Right after DTS, query doesn't work anymore?!	rweide	Classic ASP Databases	6	January 21st, 2005 04:11 PM
dts calls a lot of dts	steffi_ma	SQL Server DTS	2	May 24th, 2004 07:18 PM
Syntax error in query. Incomplete query clause.	dispickle	ADO.NET	3	April 16th, 2004 01:04 PM