You mean to say that SQL Server Agent does nt work in SQL Express 2008 ? or is there any work around for to make Agent running?

Hi Guys,

I will make my requirement more narrow.

Is there will be an entry for dynamically created job inside my stored procedure ? If anyone can answer this question. This would...

Thank You.

Can we do the same thing using update and corelated sub-query?

Mukti (1/12/2009)

---

You cannot set an object type variable like this. What exactly do you want to set? Object types are generally used to store full resultset from a query or...

Thank You so much!

Thank You so much Guys.:)

Have a look at this link

http://blogs.conchango.com/jamiethomson/archive/2007/04/26/SSIS_3A00_-Storing-passwords.aspx

Just go through the below link. Hope this would help you out.

http://www.sqlis.com/26.aspx

Thank You!

Thanks Micheal!

Hi Micheal,

Thanks for the responese.

But if i want to open the copied packages at local environment what need to be done? is there any to turn...

Dear Squared,

You are perfect!

That is what i require.

Can u give me example for implementing this using a SELECT.

That would be a great help.

I tried...

Thanks for the help!

Thanks!

Hi,

This video helps you a lot in understanding the Transactions within SSIS

http://www.jumpstarttv.com/Media.aspx?vid=39