Delta loads with a DTS package

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Delta loads with a DTS package

Author

Topic

krishraj19
Starting Member

1 Post

Posted - 2007-07-25 : 23:33:03

Hi all,
I am new to this forum.
I have a question on DTS packages.
I am trying to create a DTS package which loads the data in target
table(ORACLE).
Is that possible to create DTS package which do full load when i run
the package initially and delta loads whenever i run the package
later?

I am not creating any Stage table, i am directly dumping into
Warehouse table.

Can anyone help me how to create that?

Thanks
Raj

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-26 : 23:28:29

Possible since you can run sql execution task in dts package, but may expensive than staging table.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources