Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

My boss has a kindle and likes to save a lot of stuff to his clippings. Currently I'm going through and cutting out each clipping and pasting it into a seperate word document with the title of the article. I have managed to import the txt file into sql server and have generated an SSIS package to clean up the data and to provide me with what I want. The part that I'm having difficulty with is being able to take each article and generate a word document. Is there a way to do this with SQL Server and Intergration Services?

edit- Definition of the data that I have:

create table dbo.Articles
(
PK_ID int identity(1,1),
Title nvarchar(50),
Article nvarchar(max)
)
share|improve this question
1  
I'm curious are you doing this for your benefit or your bosses? Have you thought of just using PowerShell? If you are just wanting to break up the text file into Word documents that can be done with PowerShell without much fuss. –  Shawn Melton Sep 19 '11 at 18:28
    
@Shawn Melton, both. He want's it in a readable format on the computer and I don't want to spend 2 hours cutting his clippings into 60 word documents. I'm not familiar with powershell at all. –  DForck42 Sep 19 '11 at 18:31
    
Can you provide a sampling of content in the text file or table format you have to your question? –  Shawn Melton Sep 19 '11 at 18:40
    
@Shawn Melton, yes, but I won't be able to until later tonight. –  DForck42 Sep 19 '11 at 18:43
2  
I think this is a great place for this question. I would also look to PowerShell. Learn the basics of PowerShell and then you'll know what to reference. There are plenty of database professionals here that are just amazing with PowerShell. –  Thomas Stringer Sep 19 '11 at 23:56

1 Answer 1

up vote 0 down vote accepted

If you have SQL Server and SSIS, you should also have Reporting Services.

This can generate Word documents. This can be interactive, or you can use URL access, or SOAP calls to get at data.

May not be ideal, but it takes away the need to try and write Word documents via scripting or code: you just need some way to invoke what MS provide

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.