October 7, 2015 at 5:08 am
Hi all,
how to load the data from oracle to sql server
oracle source is having 7 tables
sql server target is having 7 tables
i have used VISUAL STUDIO and created the one data for individual
but how to run in sql server that ssis package
Thanks for more help!!....
October 7, 2015 at 6:06 am
Deploy your SSIS project to SSISDB on your SQL Server instance. Here[/url] is a link that illustrates that process.
Now you are in a position to create a scheduled SQL Agent job which will execute the deployed package.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 7, 2015 at 6:36 am
There are also a number of ways to simply call the SSIS package directly.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 9, 2015 at 2:07 am
Hi,
Just add 7 packages to the SQL Agent as a job with different steps and schedule it according to your requirement.
October 9, 2015 at 2:11 am
baddulahariprasad (10/9/2015)
Hi,Just add 7 packages to the SQL Agent as a job with different steps and schedule it according to your requirement.
7 packages, a bit overkill.
Why not 1 package with 7 DFT's?
October 9, 2015 at 2:28 am
deployment is done but while execution getting error
Thanks
October 9, 2015 at 2:30 am
botta.5283 (10/9/2015)
deployment is done but while execution getting errorThanks
Please can you post the error?
October 9, 2015 at 2:32 am
anthony.green (10/9/2015)
baddulahariprasad (10/9/2015)
Hi,Just add 7 packages to the SQL Agent as a job with different steps and schedule it according to your requirement.
7 packages, a bit overkill.
Why not 1 package with 7 DFT's?
I agree.
Or one package which calls seven child packages.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 9, 2015 at 2:33 am
"Data Flow Task 1:Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager ""SourceConnectionOLEDB"" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
"
Thanks For More help
October 9, 2015 at 2:36 am
hi All,
Actually while loading data from oracle to sql server am saved as SSIS packge so that package will be saved in some path
i need that package how to schedule dailly
October 9, 2015 at 2:37 am
botta.5283 (10/9/2015)
hi All,Actually while loading data from oracle to sql server am saved as SSIS packge so that package will be saved in some path
i need that package how to schedule dailly
The error is that there was an error connecting to the source connection (Oracle). I would check the ensure you can get the Oracle and the username passwords etc are all correct.
As for scheduling it, take a look at Phil's post about saving to SSISDB and creating a SQL Agent Job to run it on a schedule
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply