DTS Error

Hi,
Can any body help me to sort out this problem

I am running a DTS package source as dbf file and destination as sqlserver database the following error occurs

for row number 2035 errors encountered so far on this
task 1. insert error, column 3 ('arch_dt', DB_TYPE DBTIMESTAMP)

when i was opening dbf file in foxbase its showing (arch_dt field) date as datatype the same when i was importing to access the datatype is changing to text type.

so daily manually i am opening in excel file and delete the records where the line error occurs.

in excel file that particular row will have some text format instead of dateformat.

how can i solve this error without manual interaction..

with regards
rajkumarIf you insert it as a chracter datatype then you can check the value and correct it.
You could also probably use an activex script on it but that would be slow.

DTS Book

Hi all,
What is the best DTS book to buy. If any body knows please provide
me the ISBN number.
Thanks alot,
Silaphet,There are a couple of good books on DTS, but I haven't read any personally.
I listed them all at: http://vyaskn.tripod.com/sqlbooks.htm#dts
Have a look and read reviews before deciding on one. Good luck!
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Silaphet" <Silaphet@.discussions.microsoft.com> wrote in message
news:AEE20802-5386-4B77-AD5C-9A7D7EEA0696@.microsoft.com...
Hi all,
What is the best DTS book to buy. If any body knows please provide
me the ISBN number.
Thanks alot,
Silaphet,|||Look at
WWW.SQLDTS.COM
"Silaphet" <Silaphet@.discussions.microsoft.com> wrote in message
news:AEE20802-5386-4B77-AD5C-9A7D7EEA0696@.microsoft.com...
> Hi all,
> What is the best DTS book to buy. If any body knows please provide
> me the ISBN number.
> Thanks alot,
> Silaphet,

DTS Book

Hi all,
What is the best DTS book to buy. If any body knows please provide
me the ISBN number.
Thanks alot,
Silaphet,
There are a couple of good books on DTS, but I haven't read any personally.
I listed them all at: http://vyaskn.tripod.com/sqlbooks.htm#dts
Have a look and read reviews before deciding on one. Good luck!
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Silaphet" <Silaphet@.discussions.microsoft.com> wrote in message
news:AEE20802-5386-4B77-AD5C-9A7D7EEA0696@.microsoft.com...
Hi all,
What is the best DTS book to buy. If any body knows please provide
me the ISBN number.
Thanks alot,
Silaphet,
|||There are a couple of good books on DTS, but I haven't read any personally.
I listed them all at: http://vyaskn.tripod.com/sqlbooks.htm#dts
Have a look and read reviews before deciding on one. Good luck!
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Silaphet" <Silaphet@.discussions.microsoft.com> wrote in message
news:AEE20802-5386-4B77-AD5C-9A7D7EEA0696@.microsoft.com...
Hi all,
What is the best DTS book to buy. If any body knows please provide
me the ISBN number.
Thanks alot,
Silaphet,
|||Look at
WWW.SQLDTS.COM
"Silaphet" <Silaphet@.discussions.microsoft.com> wrote in message
news:AEE20802-5386-4B77-AD5C-9A7D7EEA0696@.microsoft.com...
> Hi all,
> What is the best DTS book to buy. If any body knows please provide
> me the ISBN number.
> Thanks alot,
> Silaphet,
|||Look at
WWW.SQLDTS.COM
"Silaphet" <Silaphet@.discussions.microsoft.com> wrote in message
news:AEE20802-5386-4B77-AD5C-9A7D7EEA0696@.microsoft.com...
> Hi all,
> What is the best DTS book to buy. If any body knows please provide
> me the ISBN number.
> Thanks alot,
> Silaphet,

DTS - FTP Task - SQL Server 2000

Hi
Could any body tell How to download files from Internet where Source file server is using SFTP (Secure FTP)?
Note: I am able to configure and download files from Internet where Source file server is configured for FTP using FTP task in DTS Package.
Thanksone option is to download a client for SFTP, create a CMD files with commands and execute under xp_cmdshell

i.e. look at PSFTP

http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

simas|||Thank you for your valuable reply...Please inform me if any come across any alternatives...Thaks