nialldunne (3/3/2016)

---

HI There,

i am attempting to get a definitive answer on whether or not DB mirroring is supported in SQL Server 2014. I know MS have stated that it will...

Your query looks fine to me.

I would move the s.lvl > t.lvl part into a WHERE clause, but it won't have any effect on the results.

There's also no harm...

Sounds like the structure of the spreadsheet is different from how it was when the package was designed.

Luis Cazares (3/2/2016)

---

Phil Parkin (3/2/2016)

---

Luis Cazares (3/2/2016)

---

Hugo Kornelis (3/2/2016)

---

The alternative, since this appears to be some type of ETL process to feed a DW table, would be to create an...

Luis Cazares (3/2/2016)

---

Hugo Kornelis (3/2/2016)

---

The alternative, since this appears to be some type of ETL process to feed a DW table, would be to create an SSIS package.

That tool is...

SQLTougherGuy (3/2/2016)

---

Hi Phil,

If there is a way that I can separate the tags, maybe I can wrap this in dynamic SQL. I am thinking something like...

@var = 'Create Job'+<NAME TAG>,...

SQLTougherGuy (3/2/2016)

---

Hello SQL friends,

Does anyone know if it is possible to create multiple SQL agent jobs using an XML file? We are moving away from Control-M and I have an...

Precisely.

Takes more setting up initially, but...

Phil Parkin (3/2/2016)

---

Best practice is to break up the code into small chunks, each of which does essentially one thing, and...

Best practice is to break up the code into small chunks, each of which does essentially one thing, and not to...

joeshu26 (3/2/2016)

---

I'm trying to execute a package in Integration Services Catalogs and it's failing, here is the error message attached. My package includes an FTP File enumerator....

Any ideas on...

etl2016 (3/2/2016)

---

Hi,

I have a scenario SSIS --> Stored Proc.

Is there a way to error handle in such a way that if SP fails (abnormally), SSIS should gracefully...

While this may be a...

So you...

IBeDatMan (3/2/2016)

---

Hey there - I am looking to create a query that will help me pull the top 10 records from two distinct groups in a column.

I have a column...