MartinIsti MS BI blog
Sign in
|
Join
|
Help
Home
About
RSS
Atom
Comments RSS
Search
Tags
445
446
Analysis Services
BI
column order
conversion
CRM
data type
DATE
Default Member
deployment
Dimension
Drillthrough
dtexec
dtutil
exam
Excel
export
filter
identity
insert
logins
MDX
MSDB
NULL
OLAP
Oracle
OrderBy
Page Viewer web part
parameter
Parameters
process
Reporting Services
Reports
roles
ROW_NUMBER
script
ServiceAccount
SharePoint
Snowflake
split
SQL Server
SSAS
SSIS
SSRS
Star
sysdtspackages
T-SQL
Visio
web service
Navigation
Home
Blogs
Photos
Downloads
Archives
October 2010 (2)
June 2010 (4)
March 2010 (1)
February 2010 (2)
June 2009 (1)
April 2009 (3)
March 2009 (4)
February 2009 (4)
December 2008 (5)
BI blogroll (the ones I read)
Teo Lachev's Weblog
Chris Webb's BI blog
SSIS Junkie
MS BI blog
Marco Russo (SQLBi.EU)
Contact
My email
December 2008 - Posts
1
Comments
Package Deployment (SSIS 2005) - mainly MSDB-related
by
MartinIsti
Normal 0 21 false false false HU X-NONE X-NONE MicrosoftInternetExplorer4 I think SSIS's package deployment methods would need a little improvement. I hope some buglike features are fixed in 2008 but I haven't used that one yet. I set aside file...
Filed under:
SSIS
,
dtexec
,
sysdtspackages
,
dtutil
,
MSDB
,
deployment
0
Comments
Default Members vs Excel
by
MartinIsti
Today we ran into an old problem again. Let's start an AS database with a single Sales CUBE and a TIME dimension (+ several other dims). The TIME dim has a default member: [TIME].[Date].Lastchild) It works perfectly when browsing it in BIDS or SSMS...
Filed under:
SSAS
,
Default Member
,
Excel
0
Comments
Exam 70-445
by
MartinIsti
It's a quite an exciting story for me As many of you might know Microsoft has a second shot offer that lets you try an exam once more free of charge. The current offer is valid until the end of this year and the 2nd exam can be taken until June 2009...
Filed under:
BI
,
SSIS
,
SSAS
,
445
,
SSRS
,
exam
4
Comments
Multicast error
by
MartinIsti
Some months ago we began developing a simple way to log the lookup errors in our SSIS solution. First the following structure was created: As you can see the main pont of this method are the Multicast (to direct error rows into a log table (OLE DB Destination...
Filed under:
BI
,
SSIS
2
Comments
for starter ...
by
MartinIsti
How and why I started this blog...
Filed under:
BI
,
SSIS
,
SSAS