Viewing 15 posts - 8,791 through 8,805 (of 11,678 total)
BIDocumenter is a tool you can use, but it is not free:
http://pragmaticworks.com/Products/Business-Intelligence/BIDocumenter/
There is also SSIS Documenter, again, not free:
https://ssisdocumenter.com/index.aspx
There aren't many free tools out there.
You can build one yourself using...
November 14, 2011 at 2:19 am
A bit late for an answer, but here goes:
* currently there are only the Microsoft BI certifications that come close (exam 70-448 and 70-452):
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab2
* in the next version of SQL...
November 14, 2011 at 2:09 am
Jeff Moden (11/9/2011)
I'll tell you what I like to see on CV's... a list of major accomplishments and the words "Google Me". 🙂
Well, either I'm a chef cook or a...
November 14, 2011 at 2:02 am
L' Eomot Inversé (11/14/2011)
michael.french 172 (11/9/2011)
Apparently I am a Pediatric Dentist. My kids will be thrilled to find that out.
And apparently I'm a dead painter. That would startle my...
November 14, 2011 at 2:01 am
Stupid question, but did you connect to the correct server?
November 14, 2011 at 1:57 am
stebennettsjb (11/9/2011)
Spoke to soon.Ive done the below exp and it seems to work!
=Format(DateAdd(DateInterval.Day,-1,Now),"yyyy/MM/dd")
That is a great trick, I'll have to remember that 🙂
November 14, 2011 at 1:56 am
Take a look at this topic, it may contain useful information:
http://www.sqlservercentral.com/Forums/Topic659894-150-1.aspx#bm661496
November 14, 2011 at 1:55 am
Or use SSIS to integrate the data from both sources into one data warehouse (that's where it is for :-)).
That way you reduce complexity in the visualization layer - aka...
November 14, 2011 at 1:53 am
quillis131 (11/11/2011)
November 14, 2011 at 1:33 am
Welsh Corgi (11/11/2011)
Why isn't there a SQL Server 2008 Integrated Services Forum?Do you post somewhere in 2008 or do you use SSIS 2005?
A lot of the functionality is the same...
November 14, 2011 at 1:31 am
mikko.carlos (11/14/2011)
November 14, 2011 at 1:04 am
Dev (11/14/2011)
First of all, read the Data Warehouse Toolkit by Ralph Kimball.Practically an industry-standard, and a must read for everyone who starts in data warehousing.
And not to forget...
November 14, 2011 at 1:01 am
There is no LIKE operator in SSIS.
Maybe change the expression to:
SUBSTRING(Amount,1,3) != "0.0" ? "10" + RIGHT(Date,8) : Date
Notice that there is (currently) no LEFT function, so we need to...
November 14, 2011 at 12:59 am
Your caps lock is broken.
Since the number of columns varies per row and since SSIS can't handle that, you have 3 options:
* read the file using .NET
* read the file...
November 14, 2011 at 12:55 am
You're using the wrong container. As the name says it, the FOREACH LOOP container will loop for each item.
I would look into the FOR LOOP container. There you can set...
November 14, 2011 at 12:51 am
Viewing 15 posts - 8,791 through 8,805 (of 11,678 total)