Viewing 15 posts - 16 through 30 (of 58 total)
Phil Parkin (9/27/2012)
Have a look here and see how you get on. It does something similar to what you require.
Thanks Phil...
But we need to transfer the data from source to...
September 28, 2012 at 12:40 am
sqlstud (9/25/2012)
Oops - I didn't notice the forum - I should have guessed.
Are the databases on different servers? If not, SSIS is overkill here - why not just create a...
September 27, 2012 at 6:46 am
Thanks Anthony
Thanks GSquared
September 26, 2012 at 6:59 am
Hi,
IS there any other way?
Regards
SqlStud
September 26, 2012 at 5:47 am
Oops - I didn't notice the forum - I should have guessed.
Are the databases on different servers? If not, SSIS is overkill here - why not just create a stored...
September 25, 2012 at 12:49 am
Thanks Phil..
Forgot to inform that i need to use SSIS 2005. So that i can schedule it in SQL Server Agent job to run on daily basis.
How do we transfer...
September 25, 2012 at 12:28 am
Hi,
I am using SSIS 2005. IF SSIS 2008, we have MS Office 2007 provider
So,As usual, created new OLEDB connection by choosing the provider Microsoft.ACE.OLEDB.12.0 and set Extended Properties=Excel 12.0;
But got...
August 31, 2012 at 4:49 am
Thanks for the reply...
Forgot to mention..
Have to use SSIS Package to load the data
Regards
SqlStud
June 27, 2012 at 12:02 am
SQLKnowItAll (6/18/2012)
Ok, I see now. Take a look at this thread and see if it helps. I personally have never had to do this.
Thanks Jared
Regards
SqlStud
June 19, 2012 at 5:21 am
Trying to execute the SSIS package thru Sql server agent job... My concern is whether we have to set the parameters value in the Job step properties.
Please find the attachment
Regards
SqlStud
June 18, 2012 at 6:30 am
Jared,
As per your suggestion, i have modified SP(handled mandatory and optional parameters) and everything is working fine.
Is it any possible way to set/pass optional parameters in Sql Server Agent Job?...
June 18, 2012 at 1:02 am
Any solutions on this?
Regards
SqlStud
June 18, 2012 at 12:42 am
Hi,
Could you please let me know how to set the mandatory and optional parameters in SQL Server Agent job?
Regards
SqlStud
June 15, 2012 at 2:47 am
Viewing 15 posts - 16 through 30 (of 58 total)