question

TomaszMalec-3369 avatar image
0 Votes"
TomaszMalec-3369 asked ·

SSIS - getting data from Oracle - not working preview and metadata refresh

Sort of a copy of

https://social.msdn.microsoft.com/Forums/en-US/892e1cb0-9090-4406-8601-52b3a3a4fc11/unable-to-preview-oracle-ole-db-source-in-ssdt-172vs2015?forum=ssdt



But... I am in need to create new VM with tools to develop already deployed application that uses SSIS to grac data from Oracle 12.

And... I can not create SSDT env that would make it possible.

Every single possible combination (version) i checked of tools (Windows, VS, SSDT) end up not working.



It's not that I can not create SSIS package. It's that it IS horrible experience...

Because... To change any metadata of column already developed I need it to be removed and added again. Not to mention that Preview crashes the way it is described in the mentioned above thread.

I can not create recommendation right now what VS (2015/2017/2019) or system (8.1/10/2012R2/2016/2019) will work at all. Not the best, but working at all.

Please advice.

P.S. Not my idea to create tags that do not match SSIS on SSIS forum... (or so it was stated in redirection)

sql-server-integration-services
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Looking at the thread you linked and going through your post, it sounds like you A) want to give feedback and B) are looking for a better Visual Studio solution.

To give feedback, use any of the methods outlined in this document:
https://docs.microsoft.com/en-us/visualstudio/ide/feedback-options?view=vs-2019

If you experience problems with Visual Studio—such as crashes, sluggish performance, or unexpected behavior—let us know by using the Report a Problem tool. In Visual Studio, choose the feedback icon in the upper-right corner, or choose Help > Send Feedback > Report a Problem from the menu bar.

To find a better Visual Studio solution, I would go to the Visual Studio forums where the product group and community are actively answering questions:

https://developercommunity.visualstudio.com/spaces/8/index.html



0 Votes 0 ·

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered ·

Hi @TomaszMalec-3369,

Please Download SQL Server Data Tools (SSDT) for Visual Studio.

And then use Oracle source in SSDT.

Best Regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.