Hi Paul

Thanks for Short explanation about Oracle RAC.

...

Raunak

It's really good start here. And thanks for quick answering a these tiny question.

Hi Raunak Jhawar

I posted a question in DATA MINING forum.

Can you please...

1. Create EXECUTE SQL TASK and write TRUNCATE TABLE table2

2. Create DATA...

1. I tried both the way, on performance front EXECUTE SQL Task is

good as compared to DATA Flow’s.

...

yes, cost is big concern.

But, I like to know on technical front.

🙂 I said, I am just OCP Oracle, not a SQL Server DBA.

I am not into Database administration.

that's great thought "Career Growth",

this gives me alert that, I have to sometime like this.

that true, I finished my OCP (DBA Track). that's not problem

yes, in case of SQL Server Or DB2, I am exploring it.

Actually, I am intracting with mulpital RDBMS during my assigments.

So, I thought of building Competency within mulpital database systems.

So, you can say finding...

Thanks paul

Recently, I start working on the SQL Server of Version 2005.

...

I suggest, to enable logging in package then collect log in text file.

and send that file as attachment through mail.

It better to pick any book which talks about every task in SSIS,

and then just try out your own.

If it is showing X sign, then just run you r package,

It will validate your entire package, and complete error message will popup on your screen.

If it is showing...

Script task is to create custom compontant, i am looking for inbuild compontant.