Post reply

Store text file (label) as an image within SQL 2005?

  • October 21, 2009 at 7:15 am

    #205812

    Hi,

    I have a text file which I need to store in a secure environment. Each text file is formatted as a 'label' with multi-lines and the layout needs to be held 'as-is' (each line has its own left/right/centre adjustments), so that when it is stored, the text positioning (format) remains the same.

    Can this be stored in/retreived from SQL Server?

    If so, how do I import it? Can I use T-SQL or Integration Services?

    Thanks in advance,

  • October 21, 2009 at 5:33 pm

    #1069195

    Hi,

    Yes, you can store files (up to 2GB in size) in database in columns of type varchar(max) or nvarchar(max). The files will have all formatting preserved. You can use SSIS if you want to do the job, but even a small client app will work.

    Regards

    Piotr

    ...and your only reply is slàinte mhath

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply