Sushant Yadav (12/21/2015)

---

Hi All,

Need your help in below scenario.

We have SSIS packages which involves Oracle and SQL servers. We have logic like when data is transferred to Oracle from SQL...

Let me advise you against that. You'll get an error.

joshdbguy (12/21/2015)

---

I have some developers that want a bunch of fields added to an existing table (it's fairly new) including a GUID field (UUID). My recommendation was that instead of...

s.kandepi3 (12/21/2015)

---

I am inserting some data from a self join CTE into a table. When i do select * into to load data into that table it works fine. But...

Did you even check BOL for this? It's something which I would expect someone with thousands of SSC...

It's a readability word. You can omit it if you choose (much like the word AS when aliasing columns).

butcherking13 (12/18/2015)

---

I was looking to see if there is a pattern or average by response to see if I might be better off creating another instance and moving some databases...

butcherking13 (12/18/2015)

---

I was wondering what do you all think or have as an average of databases per instance?

At what number are you comfortable with before you want to move to...

We'll done. I'd forgotten about that trick.

The OP does not mention any requirement for an import.

only4mithunc (12/17/2015)

---

Hi All,

I have a requirement in which I have multiple CSV files ( columns and data are different in each file ) and I need to load this into...

Easiest way I know is to create two separate files and then use an Execute Process task to append one to the other

copy file1.txt+file2.txt all.txt

Alvin Ramard (12/17/2015)

---

Phil Parkin (12/17/2015)

---

loki70 (12/17/2015)

---

Grasshopper - That worked perfectly! I never stumbled on this "preview" version in my searches, but your link worked great.

Thank you very much for...

You could...

By the way, SSIS is quite happy to handle direct connections to servers (ie, there may be no need to use a linked server within SSIS itself).