The package will only be upgraded if you try to execute 2008 packages in a 2012 environment.

Since you don't have SQL Server 2012, you don't need to worry about this.

Phil Parkin (4/10/2014)

---

peter 89731 (4/10/2014)

---

Hi,

The company I am working for has a 2008r2 server and packages developed using bids 2008. They are also using TFS, and because of some...

Good article about the basics. Lots of screenshots, well done 🙂

I have been using SSIS for 5 years, been writing about it for 2 years, but I never realized there...

Grant Fritchey (4/10/2014)

---

Nope.

And in my experience, it's not a small percentage. On average, I found people with certifications to be less able than those without. Over about a three year...

How are you trying to make the connection?

Gail was a bit faster, but anyway...

MSDN doesn't say it explicitly, but one of the rules of using a sequence object in a default contstraint is the following:

The table and...

OK. What is the exact error message?

Open up SQL Server configuration manager and check if the named pipes protocal is enabled.

Good call. You can sort in...

Sarwan (4/9/2014)

---

I have query which populates a table.

I want to run that query across 100+ servers daily and save the output of 100 +servers in single table so that...

WillyWonka (4/9/2014)

---

Personally I use SQL server integration services. If you're using the import/export wizard for SQL that is ssis. When you map the fields in your spreadsheet...

Megha P (4/10/2014)

---

We are going to transfer data from denormalize db to normalized db.Currently both source and destination are on same server..

but once i complete creating packages for all...

I hope everything works out.

You seem more motivated and eager to learn some of the people here on the forums asking for interview questions.

Good luck with your challenge!

SSIS versions are not backwards compatible (unfortunately).

VS 2013 is used for SQL Server 2014, VS 2010/12 is used for SQL Server 2012.

You can download the VS 2012 SSDTBI shell here:

http://www.microsoft.com/en-us/download/details.aspx?id=36843

I prefer physical books, but due to the high costs and the limited amount of space in my house I can reserve to store books, I only get physical books...