Not really helpful, because neither of these is a data file.

Not sure what sort of answer you are looking for here.

BCP...

SQLRNNR (8/10/2016)

---

GilaMonster (8/9/2016)

---

Minimum config isn't necessary. SQL just has to be started in single...

I think that the 'Work Offline' option on the 'SSIS' menu is the closest you can get to this. But as you've already done your homework, I suspect that you'll...

ChrisM@Work (8/9/2016)

---

TomThomson (8/9/2016)

---

It's more...

I don't have practical experience of this – only what I have read –...

So it's this row that generates the error?

EXEC master.sys.xp_create_subdir @DatabaseDailyFolder;

If so, I think you might have to modify your code to capture the execution status of the xp and then,...

Does anyone else subconsciously say "You can say that again" whenever they read this comment in auto-generated code? 🙂

koti.raavi (8/8/2016)

---

I will try converting the data after loading. One more question , string data what we have in text file having some spaces.What is the best way to do?....

Wow, those double quotes are really throwing the SQL parser off, makes it difficult to read.

It's probably obvious, but I didn't see it. Which line of code is (deliberately) creating...

Did you read this page? Explains compute node/head node differences at least.

TomThomson (8/8/2016)

---

So without more information it looks to me as if it would be very easy indeed to deliver something on a sliver platter and discover that what was wanted...

Then I am out of ideas right now.

Can you try this on another machine ... perhaps on a local instance...

PSB: you've been here long enough to be aware of the code="sql" tags. Is there a reason why you choose not to use them, to help others read your posts?

So, to confirm, the target table is a heap – is that correct? Or does it have a primary key?

Are you loading in series or in parallel?