10e5x (12/10/2012)
So now my first task will be go google research on how to write stored procedure in SSIS? Am I right?
Oh my. As you said, you really are new to all of this. I have to hand it to your for taking on such a task with so little knowledge of SQL Server.
To begin learning about stored procedures, I guess I'd have you open SSMS (SQL Server Management Studio) and press the {f1} key to get into the free help system known as "Books Online". Once that shows up on the screen, paste the following lookup innto the "Look for:" box and press enter. Follow your nose from there. Go throught the links in the order given.
stored procedures [SQL Server]
--Jeff Moden
Change is inevitable... Change for the better is not.