ETL and Data Integration tools - Modern ETL software for everyone

Here's what I need to do:

I have a remote MSSQL database for our ecommerce site.

I need to frequently take a data file that is the updated prices for all the products and import it into the database to update the product's prices.

The source data if just

[productID]{tab}[Price]

The target data is in a table called [database].[dbo].[bvc_Product]

I downloaded your Visual Importer and installed it.

I got it hooked up to our database, I set up the destination table, set up the source file, and did the mapping.

When I run the import, all I get is errors/rejects.

I'm guessing that there is a switch somewhere were I tell your tool that I want it to update records, not create new ones. I'm guessing that in this case the import is failing because it's trying to create new records that have ID that already exist.

Can you help me out here? If I can get it to work for me, I'll buy it!

Regards,

Todd

Todd.

You need to do the following
1. Click Transformation and choose Update records
2. Specify your update key fields
(Update key Check box at the bottom of the mapping panel)

to get you better understanding consider sql statement below
update prices
set price=:price
where price_id=:price_id
Price_id is Your update key

Mike

Specify your update key fields

>>>> What do you mean by this?

Update key Check box at the bottom of the mapping panel)

Hmmm...

So in my case where my source data is
[productID]{tab}[Price]

In the destination data area, I would place a check mark next to productID in the Key field and check the Update Key in the mapping screen?

In case you haven't noticed, I'm one of the people that was attracted to your statement:

This version was especially designed for none technical people.

I know what SQL stands for, and that's about it.

Todd

Got it to work. Yea!

Thanks a lot