Showing posts with label jpeg. Show all posts
Showing posts with label jpeg. Show all posts

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.

Tuesday, February 14, 2012

Do you recommend storing images directly into the DB?

The images each are in Jpeg format (black and white, with some grey scale). File size wise, wouldnt be huge < 50 KB.

There wont be too many people using the system.

Would it be tedious to maintain? Many people recommend storing the path to the graphic instead.

Please advise. Thanks.98% of all articles or opinions I've seen reccomend storing them outside the DB. SQL is not a good storage mechanism for files.

HTH|||Originally posted by fused
The images each are in Jpeg format (black and white, with some grey scale). File size wise, wouldnt be huge < 50 KB.

There wont be too many people using the system.

Would it be tedious to maintain? Many people recommend storing the path to the graphic instead.

Please advise. Thanks.

We have a proffesianally built imaging system that stores all the images on the disk and just references them from the database.

I agree that they should be left outside the DB.|||Originally posted by jimpen
We have a proffesianally built imaging system that stores all the images on the disk and just references them from the database.

I agree that they should be left outside the DB.

Right now, we are planning a project to store some images. What's the scripting language that you use? Any advice? Thanks.

So you guys have a file server that has permission given to everyone? And when you upload the pic, the picture is moved to the shared file server? And a path is inserted into the sql server?

Please advise.|||I have an ASP app that does this sort of thing. I read through the directories, and display the file names as hyperlinks without even using a db connection. This method works really well if you can get the user to name the files in such a way that the links on the page look ok...which is normally not an easy task, but it's worked pretty well for me...But this is an IntrAnet app. , not a web app..|||We use ASP.Net with C# on Windows IIS. You know the IP of the computer, create a sub directory (eg /Images) and use a component that looks in this directory (we use Borland C# Builder but Visual Studio will have this probably as well). To let users upload their images, you can use ASPUpload (www.aspupload.com)|||Originally posted by fused
Right now, we are planning a project to store some images. What's the scripting language that you use? Any advice? Thanks.

So you guys have a file server that has permission given to everyone? And when you upload the pic, the picture is moved to the shared file server? And a path is inserted into the sql server?

Please advise.

Ours is provided by a VAR of http://www.imagesoft.com/.

Read permissions are given by group as well as write. We have different sections that are available to different groups depending on what they need/are allowed to see.