Well, if the CASE statement looks up one certain column, you can use CASE column WHEN 'value1' THEN 'a' WHEN 'value2' THEN 'b' ELSE 'c' END AS ... In such cases, you don't need to write the column in all when then blocks. select *, CASE JobTitle WHEN 'Manager' THEN 'Leadership' WHEN 'Developer' THEN 'Technical' WHEN 'Analyst' THEN 'Functional' ELSE 'Other' END AS JobCategory FROM EmployeeTable ;
There is no inbuilt component in SSIS to extract the data from .wav file. You would need to find some code in C# if you can find out to do that. If you found something then you can use that code in Script task to load the data. I have personally never imported it.
Assalamualaikum warahmatullaahi wabarakatuhu Ahmad bhaiya I am new to ssis, Mera ek doubt hai mere company me 2 ssis dtsx files bat file se run ho rahe hai task scheduler se Aur dono dtsx files k connection managers me jitne bhi database servers hain wo decommission ho gaye aur ab hamko connection manager me new servers add karna hai Q. Kya ham directly dtsx file open kar k connection manager me change kar sakte hai ya sln file se he change karna hai? Is par ap ka jawab ka muntazir hun Jazakallaahu khairan kaseera
Wa alikum asslam warahmatullaahi wabarakatuhu. Humko ek naya solution banarkar, un packages ko add karna hoga, fir connection manager me change karna hoga, package ko save karke wapis se use kar sakte ho.
Hi sir , please make more videos on sql server advanced concepts. It will be really helpful
sure, will do.
Well, if the CASE statement looks up one certain column, you can use CASE column WHEN 'value1' THEN 'a' WHEN 'value2' THEN 'b' ELSE 'c' END AS ... In such cases, you don't need to write the column in all when then blocks.
select *,
CASE JobTitle
WHEN 'Manager' THEN 'Leadership'
WHEN 'Developer' THEN 'Technical'
WHEN 'Analyst' THEN 'Functional'
ELSE 'Other' END AS JobCategory
FROM EmployeeTable
;
Yes, you are correct.
Hi sir, can we extract data from .wav files using ssis. Could you please help me on this . thanks ...
There is no inbuilt component in SSIS to extract the data from .wav file. You would need to find some code in C# if you can find out to do that. If you found something then you can use that code in Script task to load the data. I have personally never imported it.
Assalamualaikum warahmatullaahi wabarakatuhu Ahmad bhaiya
I am new to ssis, Mera ek doubt hai mere company me 2 ssis dtsx files bat file se run ho rahe hai task scheduler se
Aur dono dtsx files k connection managers me jitne bhi database servers hain wo decommission ho gaye aur ab hamko connection manager me new servers add karna hai
Q. Kya ham directly dtsx file open kar k connection manager me change kar sakte hai ya sln file se he change karna hai?
Is par ap ka jawab ka muntazir hun
Jazakallaahu khairan kaseera
Wa alikum asslam warahmatullaahi wabarakatuhu.
Humko ek naya solution banarkar, un packages ko add karna hoga, fir connection manager me change karna hoga, package ko save karke wapis se use kar sakte ho.
@@learnssis Jazakallaahu khairan kaseera Ahmad bhaiya understood well
@@tahirhussain2994Thank you.