How to create DTS in SQL Server 2012.And for File uploading to Database is DTS is the best Approch?


  • I need to Upload after brwosing files from the local directory to SQL Server 2012 Database.Is DTS is the way to upload the files in the database.If yes,then what is the steps to do for this.As i am new to use DTS in SQL.Please do the need full.I need it urgently.
    Thursday, July 12, 2012 7:11 AM


  • Hello,

    I would first question why you would be saving files inside of SQL Server and not using filestream. Secondly, is there nothing in the application to facilitate this?

    There are multiple ways of getting files into SQL Server. Can you use DTS? Sure. You could also use BCP, and with 2012 there is the new FileTable type.

    Maybe if you could give us a little more information we could help you a little better.


    Sean Gallardy, MCC | Blog

    Thursday, July 12, 2012 3:49 PM