How to work on DataDrivenQueryTask2 ?

Posted on 2003-03-10
Medium Priority
Last Modified: 2008-02-01
Is it something different from DTS or the same.
I need to pull data from Oracle giving some conditions which needs a multible tables crawl and get the data and publish in SQLserver. The connection is in WAN.The data size can be very huge.
Can we write activex scripts and work, Is any sample available for that.
Question by:Neelamjain

Expert Comment

ID: 8106582
What is wrong with DTS?

You coulde write scripts to pull the information in, but that could be a lot of work.

Some questions:
1. How frequently do the updates need to happen (eg Real Time or daily updates)?
2. How reliable is the WAN connection?
3. What is the level of control of the Oracle server, ie can you implement a solution that requires some work to be done on the Oracle box?
4. How much information are we talking about?
5. Are there special conditions on the data or is it just a case of pull all information from x tables?

Author Comment

ID: 8117886
Thanx for reply.
Answers to your questions
1. Updates happen weekly.
2. Though it's reliable, it cannot be much assured on WAN, when it fails or gives end of file communication.
3.No we donot have anycontrol on ORA server.
4.it should be around 2GB of data each week per server.
5. there are some conditions for getting incremental data.. but has to get from x tables.

My Query..
What is the main difference between DDQ and DTS, what and how exactly you can use DDQ for. the Books online doesn't give a very clear picture.


Accepted Solution

David_Cameron earned 1000 total points
ID: 8123415
DDQ stands for data driven queries. BOL seems quite information on this. Read the section titled Data Driven Query Task. Data driven queries are a tool that can be used by DTS, they are not a replacement for DTS.

If updates happen weekly there are other options. One good one would be to dump the data to some other format (eg csv file for each table), FTP the file(s) from the Oracle server, and import from there. Importing from the text file would be faster if you were to use BCP.

Take a look at the following link, it describes all the different options pretty well, although from a different perspective:

I am still unsure as to why you don't want to use DTS.

Expert Comment

ID: 9276034
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Post your closing recommendations!  No comment means you don't care.
LVL 12

Expert Comment

ID: 11042488
No comment has been added to this question in more than 251 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
   Accept: David_Cameron http:#8123415

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

EE Cleanup Volunteer

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question