The best example I have seen of using this task is by Itzik Ben-Gan in
SQL Server Magazine.
Personally I think this task on large datasets is slow. It is used
rather like Oracle's INSERT ELSE UPDATE thing and that is slow as well.
I would look to create linked servers and use the data in that way.
"Alex Müller" <AlexMller (AT) discussions (DOT) microsoft.com> wrote
I have to Update an Access DB Table from Values out of an SQL Server Table, |
where both have an ID column (SQL Server Identity).
Some rows in the Access Tabele have to be updated from the SQL Server table
as the source.
I thought using a data driven task would be the right thing ... I need a
simple, detailed example for this simple task; BOL doesn't really help, and I
also didn't find any matching example in the web.
Now I'm fiddling the whole day with it and only get erros. I have made the
SQL Server table the source, and the Access table the "Binding table", have
made many experiments with the "Transformations", where I match the IDs and
the columns to be updated, and create an "Update" Query with question marks,
but I don't know how the matching of the question marks is made (it isn't
documented in any way), is the first Parameter the first question mark
appearing in the query ? Even when I change the Parameters under the query,
after pressing "OK" everything is reset as it was before. Have the
transformations anything to do with the question mark matching ?