Viewing 15 posts - 106 through 120 (of 271 total)
If all of your data elements in that field will always be four characters you could simply use the LEFT and RIGHT functions and concatenate the results with a '.'...
February 14, 2003 at 10:36 am
I am not sure on the relationships question but will look for the article I read regarding that. Have you checked the article(s) on this site regarding cube optimization? If...
February 7, 2003 at 9:28 pm
I was referring to the joins between the fact table and the dimension tables in the Analysis Services Cube Editor. If all of your fact table data contains the correct...
February 7, 2003 at 5:29 pm
Oh yeah...have you optimized your cube? By this, have you dumped the joins between the fact table and the dimension tables and set the leaf level keys to unique (assuming...
February 7, 2003 at 3:59 pm
What service pack are you running? SP2 was supposed to correct the resetting by Analysis Services of the connection timeout property but my experience has been the same as yours...you...
February 7, 2003 at 3:56 pm
Yep...you have more than 64,000 unique data members for that level. Look into Books On Line for 'grouping levels' and have analysis services construct an 'artificial' grouping level to break...
February 7, 2003 at 9:21 am
DTS is fine for what you want to accomplish in my opinion. Import your text file into a staging table that includes a 'record_exists' colummn (tinyint). After your records are...
February 6, 2003 at 9:27 am
Just a thought...what if you looped through your array, concatenated the values into some type of delimited string, passed the string to your global variable and then on the other...
February 3, 2003 at 5:01 pm
Obviously a flaw in my query logic! Maybbe instead of select null you could try select 1? I will try to find an example of the query I had in...
January 14, 2003 at 1:38 pm
What you want is a Execute SQL task with a sql statement something like:
INSERT INTO table2(col1, col2, col3...col26)
SELECT col1, col2, col3...col26 FROM TempContactList WHERE NOT EXISTS
(SELECT NULL FROM TempContactList t
JOIN
MasterContactList...
January 14, 2003 at 11:59 am
I have no experience in this realm, but a quick search on Google for Exceptions Analysis Financial produced 463,000 results...perhaps there is something there that will help you out?
Michael
Michael Weiss
January 10, 2003 at 10:12 am
Are you wanting to make a one-time change of the name of the ActiveX task? Or change it dynamically in the script itself? If a one-time change, simply double click...
January 10, 2003 at 9:17 am
What account is SQL Server Agent running under and what permissions does that account have?
Michael Weiss
January 7, 2003 at 5:07 pm
Can you post your ActiveX code, please? It seems like it should work the way you have it but it is difficult to tell without seeing the code. Maybe...
January 6, 2003 at 2:08 pm
First, put a sql server connection object in your package and set the parameters to the db that you are loading the data into. Second, add a text source connection...
January 6, 2003 at 11:38 am
Viewing 15 posts - 106 through 120 (of 271 total)