Re: Import Data question using DTS

From: fniles (fniles_at_pfmail.com)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 12:18:23 -0600

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.
>>
>>
>
>

Relevant Pages

  • Re: MailMerge hangs and crashes with Access on Server
    ... Since I am fairly new to working in this environment, I am not sure what you mean by an "Access group" with help to restructuring the query? ... "Peter Jamieson" wrote: ... All I know is that the performance of queries depends to a large extent on whether, for example, a join is performed on the client side, or on the server side, incurring no network traffic and potentially benefitting from caching on the server. ... There are no dialog boxes, and actually, I have now split the database, and have kept the Word templates and the Access frontend locally on my machine, and moved the backend to the server. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MailMerge hangs and crashes with Access on Server
    ... restructuring a complex query. ... discards 99% of them), or on the server side, incurring no network ... the database is locked and Word will not open the data source. ... have kept the Word templates and the Access frontend locally on my machine, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MailMerge hangs and crashes with Access on Server
    ... I have mapped out the path to the final query that is used to get to the ... the database is locked and Word will not open the data source. ... have kept the Word templates and the Access frontend locally on my machine, ... and moved the backend to the server. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Single-Threading / Performance issues
    ... SQL Server MVP ... > Early this year my database was migrated from a single CPU, ... (when a long select query is running, ... server guy also sez it's not his problem. ...
    (microsoft.public.sqlserver.server)
  • Re: Share Point Services
    ... Change the database ownership and permissions for the configuration database ... Microsoft SQL Server, and then click Query Analyzer. ... EXEC sp_changedbowner @AdminVSAccount; ...
    (microsoft.public.sharepoint.windowsservices)
Loading