Hi

Have you tried running each step one by one? Do they all execute? Secondly if they do check you have the latest SQL Service pack installed. Use this SELECT SERVERPROPERTY...

Hi

Have you tried dumping to a text file then importing the text file?

Mike

Hi

I do not have a Oracle server to test this on...But I am guessing  you are using a Transform Data Task to get the data into your DB....Can you not...

Hi

Have you tried importing the date fields into a varchar?

Regards

Mike

Hi

This might not be 100% right but as far as I know it go like this.

;           The...

Hi

You should find what you are looking for here;

http://msdn.microsoft.com/sql/teched/

Regards

Hi

Here is two things I would try...

1. Try import the data into a text file....Then into the table.. Check what it looks like in the text file and then check...

Hi

Not sure if I am sending you down the wrong route but could it not to be with the different collations on the Database's

Michael

Hi

Do you have any foreign key relationships on the table. If so...

Hi

You probably are not using ODBC to connect to SQL using .Net...So all you would need to do is ensure your client PC has the .Net Framework...

Hi

Can you not do something like this. If its a once off this should be fine

INSERT INTO Publisher

(PubName)

SELECT Distinct(Publisher)

FROM Books

---Then run this

INSERT INTO Publisher

(PubName)

SELECT Distinct(Publisher)

FROM JournalPaper

WHERE Publisher not in (SELECT...

Hi

I have worked with Crystal Reports / Crystal Enterprise extensively and my...

Hi

This is not bad to get you started. There is a whole series;

http://www.databasejournal.com/features/mssql/article.php/1429671

Hi

You could also try sawzip...Do a search on google for it.

Mike

Hi

If you do want to look at re-process your cube you can look at DTS and the Analysis Services Processing Task. 

Mike