Satheesh E.P. (7/9/2013)

---

We had developed SSIS packages in SQL Server 2012 environment. But due to some unavoidable reason we need to deploy these packages in SQL Server 2008 R2...

Easy one, thanks for the question.

L' Eomot Inversé (7/9/2013)

---

Koen Verbeeck (7/9/2013)

---

Brandie Tarvin (7/8/2013)

---

Wait. You were there for maintenance and it was closed ... so...

Brandie Tarvin (7/8/2013)

---

Wait. You were there for maintenance and it was closed ... so you couldn't do your maintenance?

(Grammar...

Steve Jones - SSC Editor (7/8/2013)

---

The Azure test is interesting, however I'd recommend you set up a virtual machine. Lots of free players, including Virtual Box.

you can then go through...

hvermaak (7/1/2013)

---

I am very excited about the new version of SQL. Downloaded the CTP for testing on one of my own machines.

I have done the same thing since the CTP...

I assume the underlying data is stored in an Excel sheet?

In SSIS, you need to specify the Excel file and the sheet to import the data.

How did you create the header?

This is known as the all-at-once concept in SQL Server.

All-At-Once Operations

This should continue to work in next versions of SQL Server.

JoshuaT (7/6/2013)

---

Quick environment details: 64 bit Server 2008; SQL Server 2012; Studio 2010

I have a package that connects to a .xlsx file via the MS access driver and...

Just avoid RIGHT JOIN altogether. It makes it harder to follow the logic from top to bottom. Also use brackets around your tables so you can easily see what's going...

Talk about abusing Excel...

Maybe a permission issue with the SQL Agent account?

Did you use a proxy to run the SSIS job step?

You can try to log the details of the winscp command to...

Why don't you use the /config switch 2008? Or you trying to overrule configs already specified in the package?

Are we talking about package configurations?