Thanks for your quick reply, but we can use cast / convert only after applying datepart function.

It would be great, if you could able send test script.

Hi Team,

Thanks for your reply...I have added those three columns in the destination table and configured the kimball SCD component. Also added derived column transformation for each of the kimball...

Hi Team,

Thanks for your reply and Sorry for the incomplete problem statement.

I am converting the Stored procedure to SSIS Packages in order to leverage the performance advantages.

So, above queries will...

Hi Team,

Thanks for your help!! I could able to resolve the problem.

Thanks & regards,

Keerthy

Hi Team,

MDS I have installed in my PC while accessing home page its redirecting to unauthorised.aspx.

OS: Windows server 2008 Enterprise Edition 64 bit

db: SQL server 2008 R2 Developer Edition

I have...

Hi,

Thanks for your reply...

If I am not wrong I will get the required output from the below code, but the challenge here is I cannot specify the column names and...

Thanks a lot for the intime help.

Thanks, will go through this articles.

Yes This is what I meant.

Thanks & Regard's

keerthy

That's a very good catch.

Thanks a lot!

Great!!

This is what I required...

Thanks

Thanks a lot for your inputs.

Gila Shaw: Yes, We need to deploy all procedures in the client environment (Database Server).

Thanks for your inputs,

Is there is any method to encrypt the stored procedure other than "with encryption" (RC4 Method) method.

As I need to send all my procedures to my client...

Awesome , Its working fine...Thanks for all you supports..

Hi,

Yes, all the fields considered to be varchar data type