November 24, 2009 at 7:38 pm
Hi Friends
I am new to SSIS 2005 .
I got 4 excel sources.I loaded the data from EXCEL into Oledb Tables.
What I am looking is
I want to truncate those 4 tables and reload the date freshly in every week .
And After loading the data I want to call stored procedure to send results to some users.
I dont know to how to do this ,any help please.
November 24, 2009 at 7:57 pm
anitha.cherukuri (11/24/2009)
Hi FriendsI am new to SSIS 2005 .
I got 4 excel sources.I loaded the data from EXCEL into Oledb Tables.
What I am looking is
I want to truncate those 4 tables and reload the date freshly in every week .
Till here whatever you have mentioned can be done with a simple SSIS Package.
And After loading the data I want to call stored procedure to send results to some users.
I dont know to how to do this ,any help please.
What is the flow is not clear, from where will you call the SP's and what should SP's do, what does "results to users" mean?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 24, 2009 at 8:10 pm
Hi
I did half the part by reading some articles in google.
1. to Truncate the Table 1st - Execute SQL Task)
2. Load the Table with fresh data - Data Flow Task)
I wrote stored procedure in sql management studio using above 4 tables.
Here i want to call this stored procedure and pass 2 paramter values ,finally send in excel format to business user.
i hope it makes sense.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply