Maybe you can turn it into an article for SSC?

Sure.

Using Multiple Versions of SQL Server in a Replication Topology

What about replication?

It shouldn't take that long to transfer 9 million rows.

What is the recovery model? Is the table frequently queried/updated?

You can use the Windows Scheduler.

About anything that can schedule a .exe suffices.

Personally I like SQL Agent the best, and you don't need to import your packages into SQL Server...

There are certain characters XML cannot handle, because they are used by XML itself.

For example: < > & " '

List of XML and HTML character entity references

Either unmerge the column, or don't use a header at all.

You can read out the metadata of the table from INFORMATION_SCHEMA.COLUMNS.

The columns in the flat file have to have the same names though.

Is there a question?

Greg Edwards-268690 (10/16/2013)

---

Koen Verbeeck (10/16/2013)

---

Apparently not...

SQL...

mike.hockman (10/16/2013)

---

The issue turned out to be the blank string variable at run time. As soon as I provided an 'xx' as the value for the variable, the...

Apparently not...

SQL Server 2014 Community Technology...

Downloading SQL 2014 CTP2 right now. Somehow didn't find a VM with Windows Server 2012 and SQL Server 2014 pre-installed, like with CTP1.

Unless I missed something?

Can I install CTP2 over...

Koen Verbeeck (10/8/2013)

---

Looks like I know what I'll be doing the next months...

mike.hockman (10/16/2013)

---

John, building the variable as the query containing the values is a decent idea, and may in the end decide to go that route. However, this seems like...