Hi Mike,

How you dropped only Default Constraints ?

Regards

Chaithanya M

Hi,

thanks fore reply.Could you please expalain how this worked by adding a ']'. How does sql server treat this ?

Regards

Chaithanya M

Hi,

Thank you very much for quick answer. that was Awesome . One more quick question i have is ,...

Hi Gail,

Thank you very much for your reply. One more thing i wanted to know is,...

Hi ,

Thank you very much for the quick reply. so there's no term called Microsoft join ?

What is ANSI...

Hi ,

Let me take 2 examples :

microsoft i am referring to : select * from emp ,dept where emp.deptno=dept.deptno

So, is there any...

Thank You very much for your valuable reply. One more thing i wanted to know is , whether creating index on a column whose selectivity is 16%

is good or...

Hi Koen,

Thank you very much for replying. I tried the way you suggested i.e .

I took a Data...

Hi,

What if the session is abruptly closed. For example in the example provided by me, i have WAITFOR CLause to...

Hi Koen,

I have used two For each loops . One to loop through Excel File in...

Hi Koen,

Not really the order is preserved. Thank you very much for the...

Hi keon,

I used the following url to build my package ...

Have attached screen shots of my pacakge , which also shows the expressions of the connection managers. Please do check and let me know if you need any other info...

Excel Connection string :

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\EXCEL TO SSMS\wave2_CM.xls;Extended Properties="Excel 8.0;HDR=YES";

I am just mapping ServerName to --FileName(variable) --> contains the value like "G:\EXCEL TO SSMS\wave2_CM.xls"

and ExcelFilePath ---> SheetName(variable) ...

I see the Excel sheet is in Compatibility mode, but i can open the excel source editor and view the data.

regards

Chaithu