Hi Everyone,

did anyone experienced this type of problem.

Thanks in advance...

Hi lutz,

Thank you very much and I really appreciate for your immediate response to my problem. I want to know how can I build my skills in writing...

Hi Lutz,

First of all thanks for your reply...

yes it should be switched.... i am sorry for typing mistake.

thanks in advance.

Hi Everyone,

Can anyone throw some light on this problem...

Thanks

Hi Jason,

I got the answer for that

select convert(datetime,substring('10232016',1,2)+'/'+substring('10232016',3,2)+'/'+substring('10232016',5,4),101)

Thanks for your help.

sai

Hi Jason,

First of all I appreciate for suggesting me the link. I would like to convert a varchar data which is in mmddyyyy to datetime format

Thanks,

sai

Hi Lynn,

Thank you very much. I resolved the issue by applying dynamic sql.

Thanks once again and I appreciate for your help.

Thanks

Does this package ever got executed in any other environment like DEV,QA or other. If you are using any execute sql tasks or using any for each loop container...

Hi ALL,

I request to please suggest solution.

Thanks,

Sai

If any one let me know what are the equivalent datatypes need to be used in comparision to sql server nvarchar,float,varchar,int,decimal datatypes in excel 2007.

The data gets...

Hi Tim,

First of all, I appreciate for replying to my question. We don't have 32 Bit Server. Please suggest any other alternative through which I can execute my...

Hi all,

I know cursors will degrade the performance but I dont know how to substitue them with CTE or While loop. Please help me to understand by giving examples...

Hi,

My simple advise to moderators is any kind of post whether it is simple or tuff. It should be properly handled by giving some solution. This forum is...

Hi Gila,

Please let me know if I need to post a new topic for my problem or not.

Thanks,

Sai

Hi,

I have a same similar problem and I got the content from google and I just copied the content and added my own version to it.

Thanks,

sai