Do you have any sort of logging enabled on the package itself?

Finally an answer! http://blogs.msdn.com/b/mattm/archive/2008/08/22/accessing-oledb-connection-managers-in-a-script.aspx

I found my answer. On the canned logging, there are extended properties which can give component level information.

Ok. I think I found the answer to this.

The execution ID changes when you run the package through BIDS. But if you run it from the dtexec command...

Good point Patrick.

Alsaker. If you want to select the questions and sample code and results, you will have to devise them on your own. Its hard to find ready...

Just wondering. Would you really rely on a websites knowledge to test the applicants? I mean, they would ask questions which dont even apply to your scenario. Is that what...

Try https://www.proveit.com/default.htm

+1 Lynn and ChrisM

Nidhi,

What have you tried so far? If you have a procedure for us to look at and fix, it will be a whole lot easier than creating the procedure from...

do you want to write the test or want others to write the test for you? 😛

I liked your article. I found something similar on Pragmatic works website. Just posting here as an added material 🙂 The link is http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx.

The article talks about 2 types of...

Increase the size of the the text from whatever you currently have. For example if its 10, make it 15 and try. If not, post your data.

Drop and recreate indexes..Script them out and remove the options that you dont need. I dont think that altering a live index is possible unless you are changing the columns...

Wow! Thank you all for the insightful opinions. I would agree that its more specific to a problem that one is trying to solve.

Thank you all for taking time...

Thank you all for your valuable suggestions. I think I will just try and learn new things as I encounter new problems. I will try to learn both the languages...