Re: Import Data question using DTS

From: J Hunter (ms-nntp-nospam_at_jshunter.co.uk)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 18:38:06 -0000

Ok, could you confirm the following:

1. Your using hte DTS Import/Export Wizard
2. You set up a source
3. You set up a destination
4. You provide a query

When you define a destination - does the table exist? If yes, have to tried
letting the wizard create a new table? Do you define any transforms? Does
clicking on the preview button display the desired results?

Cheers

J.

"fniles" <fniles@pfmail.com> wrote in message
news:O36yUsoHFHA.1996@TK2MSFTNGP12.phx.gbl...
> Thanks for the reply.
>
> >If you run your query directly against database a on server 1, are the
rows
> >returned?
> Yes, rows are returned when I run the query "select * from tableA where
> tableA.[DateRecorded]='02/28/05'" against database A on server 1.
>
>
> "J Hunter" <ms-nntp-nospam@jshunter.co.uk> wrote in message
> news:%23B2ZnfoHFHA.3628@TK2MSFTNGP15.phx.gbl...
> > Hi,
> >
> > If you run your query directly against database a on server 1, are the
> > rows
> > returned?
> >
> > It might be a issue with string to date convertion. Try using the
format
> > '20050228' or explicitly
> > convert the string to a datetime - Convert(datetime, '02/28/05', 1).
> >
> > If there is a time component (ie not 00:00:00) you would need to discard
> > that before doing the comparison.
> >
> > Or try: DateRecorded BETWEEN '20050228 00:00:00' AND '20050228 23:59:59'
> >
> > Cheers
> >
> > J.
> >
> >
> > "fniles" <fniles@pfmail.com> wrote in message
> > news:e4p9JZoHFHA.3196@TK2MSFTNGP15.phx.gbl...
> >> I have a database A on 1 server and database A on the 2nd machine.
> >> I would like to export data from tableA database A from the 1 server to
> > the
> >> 2nd machine, but I only want to export data whose date = '02/28/05'.
> >>
> >> When I export the data using DTS, I specify that I would like to "use
> > query
> >> to specify the data to transfer", and I wrote the query as the
following:
> >> select * from tableA where tableA.[DateRecorded]='02/28/05' and run it.
> >> It
> >> said that it successfully export the data.
> >> But when I went to the 2nd machine database A table A, I do not see the
> > data
> >> where [DateRecorded]='02/28/05'.
> >>
> >> How can I export data only where [DateRecorded]='02/28/05' ?
> >>
> >> Thank you very much.
> >>
> >>
> >
> >
>
>