visual studio - Cannot Import DTSX files back into SQL Server 2008r2 Int Services after export and edit in VSPro2013 -
i've carried out lot of work here , want able utilize dtsx packages
but version incompatibility , error message specific
but there must way can run packages. appear not able run within vs2013 pro editor
my question is, need install allow me execute these saved packages?
by asking here can save time since there many versions , many add together ons etc
first - how run ssis 2008 package?
there overview here, ashish kumar mehta of mssqtips, on how execute packages both remotely on server or locally. either way need sql server client tools installed sql server media (cd, image, etc.). there's no possibility of running bundle locally management studio or raw visual studio. can run bundle remotely through management studio if bundle stored within sql server. theoretically, can run bundle in development mode via vs2013, see below.
second - how modify ssis 2008 package?
unlike subsequent sql server (and ssis) versions, 2008 couldn't utilize regular visual studio downloadable plugin. had install 1 business intelligence development studio (bids), visual studio 2008 derivative (i.e. not plugin) available on sql server media. that's way go if want edit bundle maintain 2008 version. otherwise, you're free upgrade bundle integration services 2014 level several methods, , start hacking @ via visual studio 2013 downloadable data tools - business intelligence plug-in. advised, it's not possible convert bundle 2012 nor 2008 versions.
visual-studio sql-server-2008-r2 ssdt
No comments:
Post a Comment