I am trying to "clone" a few transforms in SQL7 from a copy of the original
database into the same export files. In other words point 2 different data
sources into the same export file. Can I do this within the same DTS
package?

By Export file I presume you mean text file.

Personally I would export to two files then use COPY in an
ExecuteProcess task or if the data is the same in each transform then
simply create a view of the data (or statement) incorporating both sets
of data (UNION) and use that as the source.

Allan

"James" <jimcraig77 (AT) hotmail (DOT) com> wrote

The data format is the same in each transform. I want to create a union
from both sources to the single text file.
Each source is a copy of the same database on the same SQL server.
I already have 2 seperate views into each of the databases, do I need to
consolidate them, or can both just transform to the same file?

James


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

OK So in one of the DBs DO

CREATE VIEW dbo.ConsolidatedDataView
AS
SELECT <col list> FROM <whatever>
UNION
SELECT <col list> FROM OtherDB.owner.<whatever>



"James" <jimcraig77 (AT) hotmail (DOT) com> wrote

Excellent, thank you much!

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote