Sunday, February 19, 2012

Documenting SQL 2005 packages

Hi all

I would like to select transforms in a package and paste them as jpeg or similar into word or powerpoint in order to allow me to create a separate set of documentation.

However, whenever I copy some transformations and jump to word, the copy buffer is empty.

Any suggestions?

Thanks

I am not sure you can do what you are after, but I am intrigued. What do you mean by copy a transform? What do you expect to see?

|||

I would like to be able to paste the 'graphical' representation of a set of SSIS objects into a word or ppt document as a jpeg or similar.

|||

Does print screen not work for you?

-Jamie

|||

Hi Jamie

The problem with print screen are:

* Firstly, the quality of the image is quite poor by the time it is dumped into word,

* But, more importantly, if all the objects don't fit on the screen at one time, then print screen wont capture them.

I could easily solve the 2nd problem by zooming out, but then I lose all detail and defeat the purpose.

A number of my data flows have 20+ objects in them and won't fit on a single A4 page.

I would like to paste an image of them onto an A3 page in word or ppt so that I can include them in the warehouse documentation.

|||

I had thought of grabbing the graphics and making them into some Visio Shapes, that would allow graphical documentation of packages, but they are not my images to do with as I wish! MS?

|||

I know it seems a little bit of a strange thing to want to do, but I am only building the warehouse and will (hopefully) take no part in the adminstration.

So, in order to provide our DBA with a fighting chance, I want to do my utmost to give as much help as possible as to the inner workings of the packages.

No comments:

Post a Comment