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  General SQL Server Forums  New to SQL Server Programming  data transfer from Oracle to SQLserver using DTS

Author  Topic  kkr12 Starting Member 12 Posts Posted - 2006-02-23 : 12:08:57 Hi, I'm trying to copy data for several tables from Oracle to SQL Server using DTS tool. When I open up the tool it asks for source and target info,etc. And I saw a option of saving it for later execution and I need to run it from sql server enterprise manager. But I want a DTS package which will transfer data between any oracle database and any sql server database(the table structures will be same in both DBs). So how can I acheive this with DTS ? Can I've an option to specify the source and target DB info at runtime ? If so please let me know . I want to put everything in a batch file so that end user can execute it just by invoking a single file. Thanks in advance, kkr