I have an old Data conversion utility written in VB6, that uses DTS. Searching around on the internet, I see that DTS packages do work against SQL 2008 R2 databases. I'm having trouble finding out whether DTS will work against newer versions of SQL. I'm trying to advise my employer whether they should update the existing utility with bug fixes, or go for a complete rewrite.
Can my employer expect DTS packages to continue functioning once they start trying to use them against newer SQL versions? Thanks!