Here's a blog post on how to do it in a source:

http://sqlserversolutions.blogspot.be/2009/02/selecting-excel-range-in-ssis.html

There is no fixed order in which you have to install anything. I usually install everything at the same time.

Haven't used it much, but it installed fine alongside SSDTBI 2010 and 2012.

Personally, I would store the prices themselves in the fact table, unless it is fixed for a certain color and size.

If it changes too often, definately in the fact table....

In the SQL Server Agent jobstep you should be able to view the command line used. Check it and see if there any differences with the command line that works.

Application name is optional and should have no impact.

Could you post the connection string to see if it is valid (change servername and stuff like that).

1. Create the environment variable and give it a value.

2. Go to the project configuration and go to references. Add a reference to the environment.

3. Click OK. Open up the...

Can you post the exact error?

At which transformation do you get the error?

Duplicate question. Original question with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1574882-391-1.aspx

Try using a range to write to instead of a sheet name.

(never tried it in a destination though)

Koen Verbeeck (5/27/2014)

---

I always get redirected to the...

I always get redirected to the following URL:

http://www.microsoft.com/library/errorpages/smarterror.aspx?aspxerrorpath=http%3a%2f%2fwww.microsoft.com%2flearning%2fen-gb%2fretired-certification-exams.aspx

paul.knibbs (5/27/2014)

---

I'm confused. When it started talking about a "separate" memory-optimized filegroup, I assumed it meant something separate from the memory-optimized filegroup you created in the first place, which is...

Interesting question, thanks.

GilaMonster (5/27/2014)

---

http://www.microsoft.com/learning/en-gb/retired-certification-exams.aspx

Being withdrawn on 31 July 2014

70-433: TS: Microsoft SQL Server 2008, Database Development

70-450: PRO: Microsoft SQL Server 2008, Designing, Optimizing and Maintaining a Database Administrative Solution

70-451: PRO: Microsoft SQL...