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?

OK, that sounds annoying, but what's your question, exactly?

OK. Does each file take the same length of time?

Are the files stored locally on the server?

seismicbeat (8/8/2016)

---

Hello,

SQL Server novice here, I'm looking for help to get through the SQL statement that I mentioned below. I have an SSAS cube that I can query with MDX...

koti.raavi (8/8/2016)

---

I'm loading the couple of text files to SQL Server Database and

each file contains 1000 records and total number of files are 15.

Problem is each file is taking more...

lduvall (8/7/2016)

---

Phil, I added the @RowCount and @ErrorRowCount variables and set a derived column to add the two together and mapped it to my error table destination, but it's not...