?
Solved

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

Posted on 2016-10-21
14
Medium Priority
?
66 Views
Last Modified: 2016-11-01
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?
0
Comment
Question by:Arikkan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 6
14 Comments
 
LVL 9

Expert Comment

by:Evan Cutler
ID: 41854488
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.
1
 

Author Comment

by:Arikkan
ID: 41854504
Its a dtsx file.

But does it matter that SQL Server 2008 R2 (Local Database) is not supported on Windows 10.
0
 
LVL 9

Expert Comment

by:Evan Cutler
ID: 41854507
at that point it's a matter of guidance vs. determination.  if the installation refuses to install, then you have your answer.  if you can install it, and get services going, then you can attempt the migration and see what happens.
1
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:Arikkan
ID: 41859085
I migrated to the new machine built as Windows 8.1 (I tried 64 bit and 32 bit machines)
I installed:

1. VS 2008
2. SQL server 2008 R2 (All components)
3. Oracle Client

But now I cannot connect to oracle using Microsoft OLEDB provider for Oracle :-(

Getting Error:
Oracle test connection failed because of an error in initializing provider. ORA-01019

I am stuck.
0
 
LVL 9

Expert Comment

by:Evan Cutler
ID: 41859091
what version of oracle?
0
 

Author Comment

by:Arikkan
ID: 41859092
Oracle version is 11.2

(PS. I did install VS2008 with SP1)

I tried with a UDL file on desktop and have the same error.....
0
 
LVL 9

Accepted Solution

by:
Evan Cutler earned 2000 total points
ID: 41859180
you can try a few things:

1. Try updating your connection string:
"Provider=MSDASQL;Data Source=tprss;Persist Security Info=True;User ID=myUser;Password=myPassword"  (DEVNOTE: keep old one just in case)

2. make sure your tnsnames.ora file is correctly filled out.

3. make sure you have the right client:
http://www.oracle.com/technetwork/topics/winx64soft-089540.html
crossing the 64/32-bit lines are a bit fuzzy for windows to oracle connections.

4. Check via odbc connections in control panel.
1
 

Author Comment

by:Arikkan
ID: 41859221
Thanks. I will try these :-)
0
 

Author Comment

by:Arikkan
ID: 41859291
1. Try updating your connection string: --> I am getting the error as in the screenshot.

2. My tnsnames.ora is correct as I have picked it from machine where it is working

3. I am on a 32 bit machine. I used think link:
http://www.oracle.com/technetwork/topics/winsoft-085727.html

My oracle is Version 11.2.0.1.0
So I used this client installer:
*Instant Client Package - ODBC: Additional libraries for enabling ODBC applications

But still it did not work.
I got the error in Initializing provider.

Any ideas ?

4. Check via odbc connections in control panel --> What do I need to do here?
0
 
LVL 9

Expert Comment

by:Evan Cutler
ID: 41859302
ok.  follow the guidance on this page.
We're going off-topic here, so I'm trying the best on this one.....

but, I did this page once, and it worked for me.
https://docs.oracle.com/cd/E11882_01/datamine.112/e16807/connecting.htm#DMADM129
1
 

Author Comment

by:Arikkan
ID: 41859328
Sorry for going off topic. I will create another question on experts exchange for this issue soon.
And thanks a ton for your such good advise.  :-)
0
 
LVL 9

Expert Comment

by:Evan Cutler
ID: 41859334
no problem.  anytime, I hope you get it going.
1
 

Assisted Solution

by:Arikkan
Arikkan earned 0 total points
ID: 41869287
ok. I got it working in Windows 8.1 Enterprise (32 bit).

I had to do the following:
1. Windows 64 bit did not work (So used 32 bit)
2. Installed Visual Studio 2008 Enterprise with SP1
3. Installed SQL Server 2008 R2 Enterprise with updates
4. Migrated my solution
5. Tested OLE DB (Oracle) connection with UDL files on desktop
6. Set up Environment variables (TNS_ADMIN ,   ORACLE_HOME)
7. Ran the solution and it worked

:-)


Some good resources that helped me:

How do I know which ORA file my SSIS package is using to connect to Oracle 10g?
http://stackoverflow.com/questions/6126548/how-do-i-know-which-ora-file-my-ssis-package-is-using-to-connect-to-oracle-10g

Oracle ORA-12154: TNS: Could not resolve service name Error?
http://stackoverflow.com/questions/206055/oracle-ora-12154-tns-could-not-resolve-service-name-error

Issue connecting to Oracle source using OLE DB source:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/aaa6b14e-bc66-4c97-8035-7637342607f4/issue-connecting-to-oracle-source-using-ole-db-source?forum=sqlintegrationservices
ORACLE_HOME path inside system variables
0
 

Author Closing Comment

by:Arikkan
ID: 41869289
:-)
0

Featured Post

WordPress Tutorial 3: Plugins, Themes, and Widgets

The three most common changes you will make to your website involve the look (themes), the functionality (plugins), and modular elements (widgets).

In this article we will briefly define each again, and give you directions on how to install them.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
In this modest contribution, I want to share with the IT community (especially system administrators, IT Support Engineers and IT Help Desks) about Windows crashes/hangs and how to deal with these particular problems.
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question