Please do not crosspost. It wastes peoples time and fragments replies.

Original post with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1450867-148-1.aspx

I'll rephrase my question:

what is the datatype of col1 in SSIS (DT_STR or DT_WSTR?) and what is the encoding of the flat file you configured in the flat file connection...

sej2008 (5/8/2013)

---

I have deployed a ssis pkg that only has a script task showing messagebox.

dabaseeployment was successfully done in sql database.now I want to schedule it as job.I am getting...

Understanding Integration Services Package Configurations

Can you give some sample data?

Why don't you use the Oracle OLE DB provider to read the data?

Another option is to use the specialized (but free) Oracle adaptors from Attunity: http://www.microsoft.com/en-us/download/details.aspx?id=29283

What...

Steve Jones - SSC Editor (5/7/2013)

---

It very much depends on your business, but I can give you a few things I've seen people use.

1. AlwaysOn Availability Groups - Get some...

netmikem (5/11/2013)

---

I think I understand the idea of the parent/child differing disks configuration for SQL-A, SQL-B, SQL-C and SQL-D (although I have one big question which I ask below) but...

Yes, because I use INTO combined with a GROUP BY daily to create new tables... :rolleyes:

Bit of a trick question, but nice nonetheless.

Thanks for the question.

Interesting question, thanks.

Interesting question, thanks.

Interesting question, thanks for the effort!