Viewing 15 posts - 2,941 through 2,955 (of 11,678 total)
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
May 27, 2014 at 1:02 pm
There is no fixed order in which you have to install anything. I usually install everything at the same time.
May 27, 2014 at 1:01 pm
Haven't used it much, but it installed fine alongside SSDTBI 2010 and 2012.
May 27, 2014 at 1:00 pm
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....
May 27, 2014 at 12:59 pm
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.
May 27, 2014 at 12:55 pm
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).
May 27, 2014 at 12:53 pm
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...
May 27, 2014 at 12:50 pm
Can you post the exact error?
At which transformation do you get the error?
May 27, 2014 at 12:48 pm
Duplicate question. Original question with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1574882-391-1.aspx
May 27, 2014 at 12:44 pm
Try using a range to write to instead of a sheet name.
(never tried it in a destination though)
May 27, 2014 at 12:43 pm
Koen Verbeeck (5/27/2014)
GilaMonster (5/27/2014)
Koen Verbeeck (5/27/2014)
Is it me, but all links to microsoft learning lead to dead ends?It's you. That link works find for me.
I always get redirected to the...
May 27, 2014 at 12:38 pm
GilaMonster (5/27/2014)
Koen Verbeeck (5/27/2014)
Is it me, but all links to microsoft learning lead to dead ends?It's you. That link works find for me.
I always get redirected to the following URL:
May 27, 2014 at 12:37 pm
paul.knibbs (5/27/2014)
May 27, 2014 at 12:36 pm
GilaMonster (5/27/2014)
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...
May 27, 2014 at 12:29 pm
Viewing 15 posts - 2,941 through 2,955 (of 11,678 total)