Agnii (12/19/2016)

---

Hello All, Trying to import 2 billion rows text file into an empty table in SQL server 2016 using BCP utility and getting the error -"SQL server could...

So you should certainly know how to spell it by now! :hehe:

Thom A (12/19/2016)

---

BrainDonor (12/19/2016)

---

I suppose getting csv files sent isn't an option? It shouldn't be of course but I've already ranted about the delight of Excel files with SSIS in...

Thom A (12/19/2016)

---

Thanks Phil,

I got to step 4, and my error rows were about half of my data set. Exporting that data out showed nothing odd about it, but they...

Thomas LeBlanc (12/19/2016)

---

Sean Peffer (12/19/2016)

---

As per the other comments it easier to maintain the SQL code than SSIS derivation task and probably better to push the load onto the SQL...

Also, I think you need to specify -ServerInstance when using Invoke-Sqlcmd.

May I ask why you don't just fetch everything you need in one go, rather than the inefficient looping technique you have coded?

Thom A (12/19/2016)

---

Hi All,

I know this is an age old problem, however, does anyone know how to get around the ACE driver and overide the field type it thinks a...

Not that I know of.

allenjoey24 (12/18/2016)

---

I'm new to SQL so I'm not really sure what to do.

Also not sure if I'm on the right forum for this, If not I'm sorry.

I'm trying to modify...

Lowell (12/16/2016)

---

Phil Parkin (12/16/2016)

---

Glad you solved it. Not sure whether you know this, but if you add

using System.IO;

into your Using block (towards the top of your code module)

it allows you...

Glad you solved it. Not sure whether you know this, but if you add

using System.IO;

into your Using block (towards the top of your code module)

it allows you to use the...

mandavli (12/16/2016)

---

I have created the Integration Services package , one of the task I use is script task.

This Task checks if the file exists on the network drive.

package works...

I think you got hit by the infamous 'quote bug'. But don't let that prevent the additional coffee intake.

Grumpy DBA (12/16/2016)

---

Wow, today's spam includes a warning about BOOTY POP... dang, just as I was about to order cases of BOOTY POP for my family and friends for Christmas....