Very Computer

Currently I designing the files that we send is a delimited text file.

The problems is When the text file get transfered to the campus I dont have
any idea how to import it.

I have try to write a VB program that read the text file as a data source
then perform update to the table at the campus. But I encounted many
technical problems like it generate errors when duplication appear! And what
i want is perform update when the record is aready existed in the campus
table and append when the record is not persented !!

In this case , Which solution is best and easilest for me? Coz I only have 1
yr. experience in progranning. Should i use replication? Or ...... ?

Please help ... Appreciated for any infomations

Edwin

if you use SQL 7.0, then solution for you would be Data Transformation
Service. If you don't use 7.0, this could be the reason to purchase it.

HTH,
Dejan Sarka

P.S.: Please do not post messages to so many groups!

If you are willing to to the following, then it should work without
automatic
replication (you have to watch at - and program, too):

Add to every telex dataset you have to read in a timestamp value.
When you read this into your (M?)DB compare in case of a duplicate
entry if the new record is younger, if so - dump the old DS to another table
- so to say - a conflict table and overwrite the old DS with the newly read
entries. So you provide the choice for your boss to read a lot before he
deletes something important. So it is not your fault.

Sorry for kidding: No the serious aspect behind is: NEVER EVER DO
A CONFLICT RESOLUTION WITHOUT USER DECISION
except you are 100% absolutely, definetively safe to destroy data...

hope this helps some.

Robert

Quote:> We have to diff. databases in two diff. country country. And we have to
> upload the telex transactions to the campus every day.

> Currently I designing the files that we send is a delimited text file.

> The problems is When the text file get transfered to the campus I dont
have
> any idea how to import it.

> I have try to write a VB program that read the text file as a data source
> then perform update to the table at the campus. But I encounted many
> technical problems like it generate errors when duplication appear! And
what
> i want is perform update when the record is aready existed in the campus
> table and append when the record is not persented !!

> In this case , Which solution is best and easilest for me? Coz I only have
1
> yr. experience in progranning. Should i use replication? Or ...... ?

> Please help ... Appreciated for any infomations

> Edwin

Quote:> If you are willing to to the following, then it should work without
> automatic
> replication (you have to watch at - and program, too):

> Add to every telex dataset you have to read in a timestamp value.
> When you read this into your (M?)DB compare in case of a duplicate
> entry if the new record is younger, if so - dump the old DS to another
table
> - so to say - a conflict table and overwrite the old DS with the newly
read
> entries. So you provide the choice for your boss to read a lot before he
> deletes something important. So it is not your fault.

> Sorry for kidding: No the serious aspect behind is: NEVER EVER DO
> A CONFLICT RESOLUTION WITHOUT USER DECISION
> except you are 100% absolutely, definetively safe to destroy data...

> hope this helps some.

> Robert

And I have to decide where to perform these actions? On the VB program side
or the SQL server side(stored procedure)

Edwin

If you are willing to to the following, then it should work without
automatic
replication (you have to watch at - and program, too):

Add to every telex dataset you have to read in a timestamp value.
When you read this into your (M?)DB compare in case of a duplicate
entry if the new record is younger, if so - dump the old DS to another table
- so to say - a conflict table and overwrite the old DS with the newly read
entries. So you provide the choice for your boss to read a lot before he
deletes something important. So it is not your fault.

Sorry for kidding: No the serious aspect behind is: NEVER EVER DO
A CONFLICT RESOLUTION WITHOUT USER DECISION
except you are 100% absolutely, definetively safe to destroy data...

hope this helps some.

Robert

Quote:> We have to diff. databases in two diff. country country. And we have to
> upload the telex transactions to the campus every day.

> Currently I designing the files that we send is a delimited text file.

> The problems is When the text file get transfered to the campus I dont
have
> any idea how to import it.

> I have try to write a VB program that read the text file as a data source
> then perform update to the table at the campus. But I encounted many
> technical problems like it generate errors when duplication appear! And
what
> i want is perform update when the record is aready existed in the campus
> table and append when the record is not persented !!

> In this case , Which solution is best and easilest for me? Coz I only have
1
> yr. experience in progranning. Should i use replication? Or ...... ?

> Please help ... Appreciated for any infomations

> Edwin

Quote:> If you are willing to to the following, then it should work without
> automatic
> replication (you have to watch at - and program, too):

> Add to every telex dataset you have to read in a timestamp value.
> When you read this into your (M?)DB compare in case of a duplicate
> entry if the new record is younger, if so - dump the old DS to another
table
> - so to say - a conflict table and overwrite the old DS with the newly
read
> entries. So you provide the choice for your boss to read a lot before he
> deletes something important. So it is not your fault.

> Sorry for kidding: No the serious aspect behind is: NEVER EVER DO
> A CONFLICT RESOLUTION WITHOUT USER DECISION
> except you are 100% absolutely, definetively safe to destroy data...

> hope this helps some.

> Robert

And I have to decide where to perform these actions? On the VB program side
or the SQL server side(stored procedure)

Edwin

Quote:> basically it's really simple. There are three steps: connect to source (in
> your case the text file), connect to destination (SQL Server), and pump
the
> data. While pumping you can do nearly anything - any transformation you
> need. You can use ActiveX script to check for existing records and update
> them and then to import new records.

> However, you can always do the import in two steps, if this is easier for
> you: import everything to SQL in temporary table and then work further
from
> temporary table.

And... I know how to retrieve the text file to act as a data source in VB
...But I donno how to translate it to a table (I want to convert it in batch
, not in every fields)

Would u mind to give me some source code..I'll be very appreciated.

Thanks
Edwin