I've used Json.NET from Newtonsoft in an SSIS process which deserialised JSON & it worked very well. I imagine it would work just as well while serialising.

homebrew01 (1/11/2017)

---

I was just hoping there was an earlier version of Upgrade Adviser that works with older OS... that maybe I missed in my search.

Since people upgrading SQL are...

Stylez (1/11/2017)

---

Good Afternoon Guys,

I am fairly new on creating SSIS and was able to create a very basic and simple SSIS package. I would like to ask how do you...

Nita Reddy (1/11/2017)

---

from the below table I need the Last_data and last_data from 6 month. with different DB_name

so my output would look like :

DB_name backup_start Backup_finish

Stock_any 8/1/2016 8/1/2016

Stock_any 1/1/2017 ...

homebrew01 (1/11/2017)

---

Sorry, I wasn't clear. Our Operating System seems to be just short of compatible with the Upgrade Adviser tool.

I want to run the tool to look for "BreakingChanges" etc...

OK, now I know what you mean. Though they look...

Steven.Grzybowski (1/11/2017)

---

I have built a Script task in an SSIS package on my workstation. The script task has 2 files - ScriptMain.cs and http://FTP.cs.

The script task works fine...

Based on this doc, you...

Luis Cazares (1/10/2017)

---

ZZartin (1/10/2017)

---

There's certainly nothing stopping you from using columns in one able to reference another table without making it an official foreign key. You would just have...

bsbabu2008 (1/10/2017)

---

Hi,

Thanks for your reply,

But we can't see 32- bit version (Standard edition ) in Microsoft Volume License Server center and one of Microsoft support executive say's that...

Looks like 2014 was the final 32-bit version.

Check this page: https://msdn.microsoft.com/en-us/library/ms143506(v=sql.120).aspx#Hard Disk Space Requirements (32-Bit and 64 Bit)

This is the sensible option. I had to do it last Thursday when...

By default, yes, but not necessarily.

Kannan Vignesh (1/8/2017)

---

Folks,

Hav a good day.

i need a clarification regarding usage of checkpoint in SSIS.

i set a checkpoint for single task. in this task , trying to insert a 1000...