Well done on sorting that out.

Presumably the package was originally developed for a 2012 back-end (using Native Client 10.1) which was migrated to 2014 (NCLI 11)?

Jerid421 (11/16/2016)

---

I was very close to completing Part 4 of the Stairway to Integration Services series and when I ran my package, I got this error:

[Execute SQL Task] Error: There...

Add a data conversion task to make your data types match.

GilaMonster (11/16/2016)

---

That only works if the log records are still in the transaction log (which means you need to be doing the investigation very soon after the delete; minutes, not...

If anyone here knows the ins and outs of fn_dblog, perhaps you'd like to take a look here.

kiran.rajenimbalkar (11/16/2016)

---

Hi Sir,

I found one of the solution when i did r&d,

SELECT Operation,[Transaction ID], [Begin Time], [Transaction Name], [Transaction SID]

FROM fn_dblog(NULL, NULL)

WHERE [Transaction ID] = '0000:535604c2' --(Use your Transaction...

Unless there...

^^^ this.

It's specific data, not more waffle, that is being requested.

Sangeeth878787 (11/15/2016)

---

Hi,

I am not into DBA, but I got a task to create view/table to display all the jobs live status to display to Non Technical Team. Could any one...

Robert Frasca (11/15/2016)

---

Create a new table based on the node, with new columns based on the elements dynamically. In this example, a new table called Log with columns: datetime, ms,...

spin (11/15/2016)

---

Hi

it's a strange one.

I have a 64 bit VM (Server 2012) with 32 bit Sage ODBC which isn't working in SSIS. I can see the data in preview...

Robert Frasca (11/15/2016)

---

My objective is to shred it and store the data in tables dynamically. If that isn't possible then I guess I'll be forced to hard code for certain...

Without using VARIANT (SQL_VARIANT_PROPERTY(@number, 'Precision')), how...

Robert Frasca (11/15/2016)

---

I haven't ruled anything out but I'm not sure how Xquery can help me when I don't know what is in the XML at the time I'm trying...

Robert Frasca (11/15/2016)

---

Here's my scenario. I have a table that looks something like this:

CREATE TABLE [dbo].[Logs](

[rowGUID] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[lngClassID] [int] NOT NULL,

[DateTimeUTC] [varchar](20) NOT NULL,

[lngSessionID] [int] NOT...