I did it fine. I created an Oracle connection and a destination text file connection then used transform data task to put the data into the text file.

It worked fine.

You can create a global variable 'Transdate'

First step create dynamic property, click 'add', then click on the global variable 'Transdate', press edit, change source to 'Query', then put in...

I agreed. The company should take care of its own equipment, and I will take care of my own. 

The (+) is outer join mostly using in Oracle.  It is not ANSI standard.

SELECT * FROM table1, table2 where table1.b = table2.x (+)

It means if x in table2 can't find...

If you create a job, then in each step, in the 'Advance' you can specify what to do when the step fails.

In the job itself, there is a 'Notification' tab,...

I assume you have data in the table. Every time you alter a column in a table, SQL Server will copy all the data in the old format to the new format. ...

I don't understand what you are trying to do here:

CASE WHEN ISNULL(paf.new_housenumber,'')

There is a problem with the same developer supports the application all the time.  If anything happens, there is no backup.  It happened to my last company, one developer supported...

You may be able to contact some of the companies and ask them to show you a demo.  Then you can decide which one looks the best. 

Besides we don't buy...

You seemed to know the problem.  So why did you post to ask for help?

The police chief could not even bring himself to tell the news. He said he felt liked Kim was part of the family, it became very personal.

Did he do the right...

Can you use Execute SQL task and xp_cmdshell to execute the bat file? 

I am not sure it will work but at least it worths a try.

We also have Oracle and AS400, we use SQL Server 2000 DTS to extract data from Oracle and AS400 and put them in SQL Server 2000 dimension and fact tables. ...

The reason my company chose Hyperion is it is not just a reporting tool.  It is financial management - a planning tool for finance people, this is the main reason...

I got the definition from PC world.

(Operational Data Store) A database designed for queries on transactional data. An ODS is often an interim or staging area for a data warehouse,...