I am using SQL 2008 but I am connected to a SQL 2005 server. I have created a SSIS package in BIDS and now want to store it in the SQL Server agent on the server. However I get an error message telling the newer version (DTSX) will not work on
that server and it wont let me store it.
I am not sure if it is as easy as saving or converting the file to DTSX then saving to the server? If so how (or even should I) convet the DTSX back to a DTS file? Can this be done? Thanks
View Complete Post