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).

Create a string parameter in your package and set it to the query string.

Change your dataflow source to use what's in the parameter, not the hard-coded query.

Use different configurations to...

OK, then I am not sure I can help.

As Excel holds dates as integers (try formatting your date as 'General' and you will see what I mean), I would have...

murtzd (12/17/2015)

---

Hi all,

I'm experiencing a very frustrating issue. I am using the guide below to read a cell value in Excel into a SSIS variable;

http://www.techbrothersit.com/2013/11/ssis-read-excel-cell-value-in-ssis.html

It works very well for anything...