Viewing 15 posts - 466 through 480 (of 893 total)
Go to Tools >> Choose Toolbox Items >> COM Components
The Attunity connectors should be in that list for you to add. If not, you may have to manually register the...
April 21, 2015 at 10:17 am
You'll need to manually add the components in VS, see the thread here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9a362710-1cfa-41f0-a7e1-54fdaed9123c/attunity-option-not-showing?forum=sqlintegrationservices
Also note that the designer of SSIS runs in 32-bit mode, so you will have to install...
April 20, 2015 at 4:35 pm
Yes, there is a way to influence the behavior of the null values. You can set/change these in your error configuration properties.
With that being said, it's really best practice to...
April 20, 2015 at 4:29 pm
The only thing I can think of that you may have missed, is changing the ErrorConfiguration property from "(default)" to "Custom".
You may have seen this already, but here's a good...
April 17, 2015 at 8:32 am
Ells (4/14/2015)
April 14, 2015 at 10:45 am
It looks like those connections use a DSN, and you probably don't have the DSN on your local machine (assuming you are opening the packages locally).
If you're opening the...
April 14, 2015 at 9:59 am
Yep, there are certain things I just don't do with the built-in tasks (and developing a .NET script is fairly easy for these):
April 13, 2015 at 2:20 pm
To be honest, I like to stay away from the built-in FTP task as I always seem to encounter issues with it.
My guess with the limited information is that it...
April 13, 2015 at 10:12 am
Ok...finally have some additional feedback. I tried a few different options, and in the end it wasn't possible to easily create a string with the status of this month and...
April 10, 2015 at 5:41 pm
VRT (4/10/2015)
I am already using this document as reference and worked on this ROLAP cube. I was really happy when I first see the data...
April 10, 2015 at 3:05 pm
My opinion: At this point, you're just trying to make a less than ideal back-end design work. I've been there a few times, and it really doesn't matter how you...
April 9, 2015 at 3:27 pm
When you refresh an entity in your Power Pivot model, it replaces all the data of that entity by default.
April 9, 2015 at 12:57 pm
Nothing jumps out at me as being incorrect. Personally, I like to stage the data and perform lookups with T-SQL...usually staying away from the Lookup Transformation. It is a personal...
April 9, 2015 at 9:22 am
alkassimdiallo (4/7/2015)
April 8, 2015 at 5:00 pm
Although old, the following article may help you to optimize a ROLAP cube (or at least point out some things that impact performance): http://download.microsoft.com/download/1/6/F/16F258DF-BB38-471B-AC4F-EC126DC9FE9B/SSAS%20ROLAP%20for%20SQL%20Server.docx
With that being said, have you considered...
April 8, 2015 at 4:36 pm
Viewing 15 posts - 466 through 480 (of 893 total)