Thanks

There is a reasonably useful article on TechNet that describes most of the work needed to import data from multiple worksheets in an Excel file with SSIS.

http://technet.microsoft.com/en-us/library/ms345182.aspx

However, the...

Can anyone give some websites also for the questions....:-)

Thanks Vishal....

I hope you are aware that an interop is a .net assembly that routes calls from a .net application to a COM component. It does not contain the COM component....

According to the requirement you give we can be able to suggest you what you need to do...

Thanks,

Arun

Can you please tell us what your requirement is???:-)

I hope you are aware that an interop is a .net assembly that routes calls from a .net application to a COM component. It does not contain the COM component....

Thank you guys....

I tried it....

Cause:

When you create a package on your local machine and create a connection in it, you have the option to save the password of that connection. However by default...

Elliott Whitlow (1/16/2012)

---

Is the process known? What I mean is that if Phase 1 returns X result you will ALWAYS go Branch A, if it returns Y then you...

!!!

This will recompile the code in your database and alert you to coding errors. Note that it will not detect errors in dynamic sql, and neither will it detect errors...