bob 66271 (8/12/2016)

---

Hi forum readers,

I just loaded SQL Express 2016 to try a few ideas. I tried a basic install and a custom install. The basic install had...

seubaid (8/12/2016)

---

i have the following Error when i execute SSIS job.

Executed as user: ALHMBWS012\SYSTEM. Microsoft (R) SQL Server Execute Package Utility

Version 10.50.4266.0 for 32-bit Copyright (C) Microsoft...

Jez-448386 (8/12/2016)

---

Temp tables only persist which the connection that created them is still active.

Why do you want a temp table?

Best practice is to create a persisted...

Sean Lange (8/11/2016)

---

Ed Wagner (8/11/2016)

---

Steve Jones - SSC Editor (8/11/2016)

---

Minor Update: The plan to replace the forums is proceeding. We've narrowed down to a couple companies, though the upgraded version...

Brandie Tarvin (8/11/2016)

---

Phil Parkin (8/9/2016)

---

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

brad.pears (8/10/2016)

---

Yes, that is certainly an option (which I had forgotten about) for sure but can be an issue if you are opening a project that had one or more...

Nice tweak, Chris. I often forget this nuance.

Luis Cazares (8/10/2016)

---

Phil Parkin (8/10/2016)

---

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

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