Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vinayakshukre
Starting Member
11 Posts |
 Posted - 2008-12-11 : 00:24:23
|
| Hello, I am trying to learn writing stored procedure and user defined functions in SQL server. Is there any way we can put them in some package like oracle ?Can we have hierarchy of packages ?Please help.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-11 : 02:06:25
|
| are you asking aboue calling SP & UDFs from SSIS package? if yes, its possible.still not sure what your exact scenario is. |
 |
|
|
vinayakshukre
Starting Member
11 Posts |
Posted - 2008-12-11 : 05:16:45
|
| Is it possible to bundle SP and UDFs as a part of SSIS package ? My knowledge about overall SQL server is almost zero. I came to know about SSIS only after googling on it. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-11 : 09:02:21
|
| Yes. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-11 : 10:03:10
|
quote:
Originally posted by vinayakshukre
Is it possible to bundle SP and UDFs as a part of SSIS package ? My knowledge about overall SQL server is almost zero. I came to know about SSIS only after googling on it.
yup you can use Execute sql task or if inside data flow task use oledb command or oledb source/destination |
|
|
|
vinayakshukre
Starting Member
11 Posts |
Posted - 2008-12-13 : 01:51:26
|
| Thanks a lot. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-13 : 01:52:53
|
welcome  |
|
|
|
|
|
|
packages for stored procedure and UDFs