Viewing 15 posts - 3,061 through 3,075 (of 11,676 total)
Tabular and/or multidimensional?
This book covers tabular well:
Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model
It's not easy though and I think they use their own code examples.
From the same...
May 14, 2014 at 7:16 am
venkat5677 (5/14/2014)
I got below error when I upgrade SSIS Package from 2005 to 2008r2.
Truncation may occur due to inserting data from data flow column "ColXXX" with a length of 255...
May 14, 2014 at 6:51 am
I guess sqlConn = cm.AcquireConnection(Dts.Transaction) is the code that breaks, as you get an invalid cast error.
When I look for sample code - Use Connections Properly in an SSIS Script...
May 14, 2014 at 6:11 am
yuvipoy (5/14/2014)
for the test of 1000 record on a table with...
May 14, 2014 at 6:01 am
martynahty (5/14/2014)
I have a stored procedure that reads a table of all the bulk load stored procedures and executes each in the correct order. How do you run Parallel ..
Withing...
May 14, 2014 at 5:59 am
yuvipoy (5/14/2014)
i have been here for couple of time but now more concern on fragmentation.
Unless you have a very good and specific reason for using GUIDS (like distributed databases or...
May 14, 2014 at 5:39 am
Maybe.
You can only know for sure by testing it.
Do you load the data in parallel?
May 14, 2014 at 5:26 am
ronan.healy (5/14/2014)
no cant see any link in any of the posts
Yeah, the fonts for URLs are really subtle.
You need to hover over the functions I mentioned with your mouse.
May 14, 2014 at 5:23 am
chandrakant_gaurav (5/14/2014)
I tried using proxy account but it didnt work either.
Well, there must be something wrong.
Are you connecting to the correct server?
May 14, 2014 at 5:22 am
ronan.healy (5/14/2014)
when i use rightRIGHT("Class",20)
just pulls back class
Did you read the documentation I linked to?
May 14, 2014 at 5:12 am
ronan.healy (5/14/2014)
you mentioned use right in one of your messages so i tired it.
im new to ssis so have no...
May 14, 2014 at 5:10 am
chandrakant_gaurav (5/14/2014)
Password to the connection manager is stored there itself. Package configuration is disabled.
Just for kicks, does it work when you use a proxy in the SQL Server Agent job?
May 14, 2014 at 5:04 am
ronan.healy (5/14/2014)
if i use thisRTRIM("Class")
it pulls back class how do i get it to pull it all back without putting more than the word class in it
RTRIM removes trailing whitespace,...
May 14, 2014 at 5:01 am
Or you can use RIGHT instead of SUBSTRING, even easier.
May 14, 2014 at 4:47 am
ronan.healy (5/14/2014)
Net Asset Value for Ignis Absolute Return Government Bond Fund . Class A GBP
Total Outstanding shares for Ignis Absolute return...
May 14, 2014 at 4:46 am
Viewing 15 posts - 3,061 through 3,075 (of 11,676 total)