I'm attempting to use DTS Import/Export wizard to copy
data from one table column to another table column within
the same database. So far I have.....

select [Customer].[CompanyName]
from [Customer]
order by [Customer].[CompanyName]


How can I modify this query string to include the syntax
that tells DTS WHERE to place the data? Thanks

Use "Execute SQL Task" in DTS with the code like this sample, where
tblLessonCurrent is a destination table and tblTempLessonStatus is the
source table. The type of join in this example works if you have foreign
keys connecting the source and destination:

update tblLessonCurrent SET
LessonStatusID = T.LessonStatusID
FROM tblLessonCurrent
LEFT OUTER JOIN tblTempLessonStatus T
ON T.UserID = tblFactLessonCurrent.UserID
and T.LessonID = tblFactLessonCurrent.LessonID;

Regards,
Ilona Shulman


"MrMike" <anonymous (AT) discussions (DOT) microsoft.com> wrote

You can use a variety of tasks here

1. An ExecuteSQL task. In this your syntax would look like this

INSERT INTO TABLE(col list...)
select [Customer].[CompanyName]
from [Customer]
order by [Customer].[CompanyName]


2. A DataPump task. In that upi specify a source which is as you already
have. You then specify a destination and then the mapping between the two.

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)




--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"MrMike" <anonymous (AT) discussions (DOT) microsoft.com> wrote