<div>
It depends on how the package has been deployed. If it's in MSDB, you can right-click the package in SSMS and choose Export Package. You can save it locally as file and the deploy that to another server. If it's on the file system, you can just copy the .dtsx file.
</div>


<div>
Its a dtsx file. <br />
<br />
But does it matter that SQL Server 2008 R2 (Local Database) is not supported on Windows 10.
</div>


<div>
at that point it's a matter of guidance vs. determination. &nbsp;if the installation refuses to install, then you have your answer. &nbsp;if you can install it, and get services going, then you can attempt the migration and see what happens.
</div>


<div>
I migrated to the new machine built as Windows 8.1 (I tried 64 bit and 32 bit machines)<br />
I installed:<br />
<br />
1. VS 2008 <br />
2. SQL server 2008 R2 (All components)<br />
3. Oracle Client <br />
<br />
But now I cannot connect to oracle using Microsoft OLEDB provider for Oracle :-(<br />
<br />
<b><u>Getting Error:</u></b><br />
Oracle test connection failed because of an error in initializing provider. ORA-01019<br />
<br />
I am stuck.
</div>


<div>
Oracle version is 11.2<br />
<br />
(PS. I did install VS2008 with SP1)<br />
<br />
I tried with a UDL file on desktop and have the same error.....
</div>


<div>
Thanks. I will try these :-)
</div>


<div>
1. Try updating your connection string: --&gt; I am getting the error as in the screenshot. <br />
<br />
2. My tnsnames.ora is correct as I have picked it from machine where it is working<br />
<br />
3. I am on a 32 bit machine. I used think link: <br />
<a href="http://www.oracle.com/technetwork/topics/winsoft-085727.html" rel="ugc">http://www.oracle.com/technetwork/topics/winsoft-085727.html</a><br />
<br />
My oracle is Version 11.2.0.1.0 <br />
So I used this client installer: <br />
<b>*Instant Client Package - ODBC: Additional libraries for enabling ODBC applications</b><br />
<br />
But still it did not work. <br />
I got the error in Initializing provider. <br />
<br />
Any ideas ?<br />
<br />
4. Check via odbc connections in control panel --&gt; What do I need to do here?
</div>


<div>
ok. &nbsp;follow the guidance on this page.<br />
We're going off-topic here, so I'm trying the best on this one.....<br />
<br />
but, I did this page once, and it worked for me.<br />
<a href="https://docs.oracle.com/cd/E11882_01/datamine.112/e16807/connecting.htm#DMADM129" rel="ugc">https://docs.oracle.com/cd/E11882_01/datamine.112/e16807/connecting.htm#DMADM129</a>
</div>


<div>
Sorry for going off topic. I will create another question on experts exchange for this issue soon.<br />
And thanks a ton for your such good advise. &nbsp;:-)
</div>


<div>
no problem. &nbsp;anytime, I hope you get it going.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have an old machine with Windows XP OS. <br />
It has VS 2008 / SQL Server 2008 R2 installed on that.<br />
We have a SSIS package that we are using on the machine. <br />
<br />
Now we want to migrate that application to a newer machine. <br />
I don't want to change the VS / SQL versions.<br />
<br />
What is the best machine to migrate this combination to ?<br />
<br />
Can I use Windows 10 or should I stick with Windows 8.1 or Windows 7?<br />
<br />
Any ideas?
</div>
</div>


Hi,

I have an old machine with Windows XP OS. 
It has VS 2008 / SQL Server 2008 R2 installed on that.
We have a SSIS package that we are using on the machine. 

Now we want to migrate that application to a newer machine. 
I don't want to change the VS / SQL versions.

What is the best machine to migrate this combination to ?

Can I use Windows 10 or should I stick with Windows 8.1 or Windows 7?

Any ideas?

Migrating VS2008 SSIS package (SQL 2008 R2)  to newer machine.

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.

SSIS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.