<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Business Intelligence
»
SSIS Mapping documentation
16 posts, Page 1 of 2
1
2
»»
SSIS Mapping documentation
Rate Topic
Display Mode
Topic Options
Author
Message
jwebber007
jwebber007
Posted Tuesday, October 19, 2010 12:05 PM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, October 26, 2011 3:46 PM
Points: 78,
Visits: 33
I am working on a large data migration using SSIS. In past projects we have used SQL stored procedures and manually generated mapping spreadsheets to provide to the client. We have now been tasked with providing this type of documentation on the current project. I would have though that generating data flow mapping documentation would be something that SSIS would do "out of the box" similar to what I have seen from Informatica. I have yet to find any solutions to this issue, and wonder if anyone on this forum has run into a similar situation and how went about automating the documentation process?
thanks in advance.
Post #1007207
Koen Verbeeck
Koen Verbeeck
Posted Tuesday, October 19, 2010 12:20 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370,
Visits: 6,468
As you said, SSIS can't provide the documentation you need out of the box.
You can check out BI documentor, but I haven't found real evidence on their site that it also can do mappings.
You can generate mappings with the ILM models in Powerdesigner, but it isn't the easiest tool to work with.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1007223
Brandie Tarvin
Brandie Tarvin
Posted Wednesday, October 20, 2010 7:18 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 10:58 AM
Points: 6,655,
Visits: 5,678
I'm a little confused. What exactly are you trying to map?
Are you just trying to show the "guts" of a SSIS package? Or is this something else?
Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA
Webpage
:
http://www.BrandieTarvin.net
LiveJournal Blog
:
http://brandietarvin.livejournal.com/
On
LinkedIn!
,
Google+
, and
Twitter
.
Freelance Writer:
Shadowrun
Latchkeys: Nevermore
,
Latchkeys: The Bootleg War
, and
Latchkeys: Roscoes in the Night
are now available on Nook and Kindle.
Post #1007708
Koen Verbeeck
Koen Verbeeck
Posted Wednesday, October 20, 2010 7:23 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370,
Visits: 6,468
Normally the mapping of an ETL flow is some sort of matrix where you "map" the input columns with the output columns.
E.g.: Input_Street + Input_StreetNumber = Output_Address
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1007713
Brandie Tarvin
Brandie Tarvin
Posted Wednesday, October 20, 2010 7:25 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 10:58 AM
Points: 6,655,
Visits: 5,678
I'd still like the OP to answer. Assumptions about this sort of thing are dangerous.
Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA
Webpage
:
http://www.BrandieTarvin.net
LiveJournal Blog
:
http://brandietarvin.livejournal.com/
On
LinkedIn!
,
Google+
, and
Twitter
.
Freelance Writer:
Shadowrun
Latchkeys: Nevermore
,
Latchkeys: The Bootleg War
, and
Latchkeys: Roscoes in the Night
are now available on Nook and Kindle.
Post #1007716
Koen Verbeeck
Koen Verbeeck
Posted Wednesday, October 20, 2010 7:27 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370,
Visits: 6,468
Brandie Tarvin (10/20/2010)
I'd still like the OP to answer. Assumptions about this sort of thing are dangerous.
Well, that's why I added "normally".
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1007719
jwebber007
jwebber007
Posted Wednesday, October 20, 2010 7:34 AM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, October 26, 2011 3:46 PM
Points: 78,
Visits: 33
Thanks for the replies. The mapping I refer to is like this;
source.last_name + source.first_name --> destination file_as_name
this is a simple example of what we are trying to achieve. Problem is we have tons of these and some of the expression logic is fairly complex.
Really just seeing if some sort of tool exists that will document this data transformation logic showing all data flow destination columns and how the source data was transformed for the insert.
Thanks again for the responses.
Post #1007727
Koen Verbeeck
Koen Verbeeck
Posted Wednesday, October 20, 2010 7:53 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370,
Visits: 6,468
Well, it can be done in Powerdesigner, but not that easily.
(and Powerdesigner isn't actually a documenting tool).
I'm going to work with Powerdesigner in the following days, I'll let you know how it works out.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1007740
jwebber007
jwebber007
Posted Wednesday, October 20, 2010 7:55 AM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, October 26, 2011 3:46 PM
Points: 78,
Visits: 33
I read up on this product after you post from yesterday and was unclear on the role it would play. Does it have the ability to read existing packages or is it a replacement for SSIS?
Post #1007742
Koen Verbeeck
Koen Verbeeck
Posted Wednesday, October 20, 2010 7:58 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370,
Visits: 6,468
No. Powerdesigner is more a data modeling tool for databases. You can document ETL (and thus generate mapping information), but it can certainly not read SSIS packages or replace them. You have to input everything yourself (unfortunately).
I think it is more worth to check out BI Documentor.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1007745
« Prev Topic
|
Next Topic »
16 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
