TheFault (8/10/2016)

---

I've created the below query to retrieve some information on agent jobs scheduled which works fine and returns 33 rows. I'm trying to pull the next_scheduled_run_date from sysjobactivity, but...

You could use a splitter. I tend to use this[/url] one, because it's been highly tested and optimised.

DECLARE @TradeRoles VARCHAR(100);

SET @TradeRoles = '1,2,3,4,5';

IF (SELECT COUNT(1)

FROM...

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