I didn't know the upsizing wizard was that funny...

Evil Kraig F (2/2/2012)

---

homebrew01 (2/2/2012)

---

The advantage of Backup/Restore is it will automatically include any new tables that get added to the database in the future.

If it's going to a different...

If some indexes include columns that have changed datatype, you could rebuild them.

AluburaJ (2/2/2012)

---

Out of curiosity, were you able to connect to that oracle database using those SQL Client tools such as...

I've hear that forums.asp.net is a pretty decent forum.

svakka (2/2/2012)

---

I'm newbie to SQL Server, mostly with Oracle background. This is what I'm trying to accomplish

1)Select deptno from dept table

2)Select all customers for each dept and process each emp...

Try the Import/Export wizard of SQL Server.

Phil Parkin (2/2/2012)

---

That's not quite true, though it certainly isn't as easy as it might be. If you are prepared...

What, you don't like the webservice solution?

Sri8143 (2/2/2012)

---

Phil,

I am doing it thru transfer sql server objects tasks which was recomended initially in this conversation so going with it as i am unable to do backup and...

Since SSIS doesn't offer you generic solutions such as functions, you need to put up a webservice. In this webservice, code a function that achieves the desired result.

In the dataflow,...

You could create a stored procedure/function in the database, and then use this in Execute SQL Tasks.

A bit more info on buffer size:

Adjust buffer size in SSIS data flow task

Another excellent article on SSIS performance:

Top 10 SQL Server Integration Services Best Practices

Are you saying we are too...

I know that Google is restricted in China, but is it totally banned in India or something?

http://www.sqlservercentral.com/Forums/Topic1245517-391-1.aspx?Update=1

(yes, I'm grumpy. Baby is stealing away much much needed sleep)