Hello,
Probabaly a silly question yet as a DOTNET developer, I'm trying to simulate DTS when for example, I don't have permission to perform DTS on a production server.
In particular and interested regards caching of rows before the service decides to flush the buffer and write to the target table. Safe to assume DTS is cursor based?
What type of cursors and where? Not really sure where that comes from, as this is not really ADO or T-SQL which is were I have com eaccross cursors before.
SSIS and DTS shouldn't use cursors for extract or loading SQL Server, just look at the connections used, standard OLE-DB stuff. All stock sources and destinations are geared towards standard connections, and they use the common providers.
The buffer is a SSIS engine feature, so not cursors either.
If you do not have permissions that allows SSIS or DTS to run then you will not be able to simulate it either, as permission requirements will be the same. If you extract data you need read permissions to run your own code or a SSIS package that does the same thing for example.
No comments:
Post a Comment