 | |
Re: Data Driven Task, basics
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Data Driven Task, basics -
03-03-2005
, 12:58 PM
|
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 ? |
#2
| |||
| |||
|
|
Did you mean "DTS and the Data Warehouse" ? Yes, thanks, this article is helpful. "Allan Mitchell" wrote: 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. Allan |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.