Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nagard
Starting Member
1 Post |
 Posted - 2009-05-21 : 13:46:29
|
| I am not very familiar with SSIS and I am debating if I should use it to import data that originates in Oracle.We have a corporate database that runs or Oracle, for which we only have limited permissions (i.e. read only, no stored procedures or anything of that sort). So I have a bunch of programs that run on workstations that import various data from Oracle to our SQL Server, at different times during the day.Some programs run every 15 minutes, others a few times a day. Presently I'm using SAS to manipulate and import the data. I want to switch to a more mainstream solution and I'm debating whether to use SSIS or C#.The only worry I have with SSIS is that with all the manipulating and importing of data, for instance every 15 minutes, I would slow down the SQL Server. As opposed to C#, which would run on a different machine, manipulate the data locally and only access SQL Server in the final step, i.e. to import the data.Are my assumptions right ?Thx in advance. |
|
|
Qualis
Posting Yak Master
145 Posts |
Posted - 2009-05-21 : 17:16:47
|
| Unless you are doing pretty heavy lifting, you won't slow down the SQL Server. |
 |
|
|
|
|
|
SSIS or C# to import from Oracle to SQL Server ?