I am trying to create a new SSIS package in SQL05 using Visual Studio. Im having a hard time getting off and running. There are alot of docs out there.
All I need to do is set up a package that sucks two tables out of an Oracle db and brings them over to a SQL 05 db at a set time each day. So I need some kind of timer or schedule funtionality. I would like to avoid using an exe and windows scheduler.
Is this even possible to do? Is SSIS what I need? Can I program this in C#?
Basically Im looking for a link or two that can get me started. Thanks
All I need to do is set up a package that sucks two tables out of an Oracle db and brings them over to a SQL 05 db at a set time each day. So I need some kind of timer or schedule funtionality. I would like to avoid using an exe and windows scheduler.
Is this even possible to do? Is SSIS what I need? Can I program this in C#?
Basically Im looking for a link or two that can get me started. Thanks