Click here to Skip to main content
15,888,009 members
Search within:


hi, how to use the CASE WHEN syntax in sql command at the component excel source editor SSIS?
Please Sign up or sign in to vote.
0.00/5 (No votes)
hi, how to use the CASE WHEN syntax in sql command at the component excel source editor SSIS?
Posted
Add a Solution
Comments
Maciej Los 20-Feb-14 17:11pm    
What?

1 solution

I'm not sure what you want to achieve, but here[^] you'll find the sample usage of SQL CASE WHEN ... END statement. But...
You need to know that OLEDB provider does not support CASE WHEN ... END statement. Rather than it, use IFF statement[^].
 
Share this answer
 
Posted
Comments
ahmed boughedda 21-Feb-14 18:06pm    
Maciej thank you, you are absolutely right, I use a component in SSIS OLEDB to query an excel sheet, then I think my sql query becomes: "SELECT prodid, IIF (prodid = 1, 'fine', IIF (prodid = 2, 'good','')) FROM MyExcel "
Maciej Los 23-Feb-14 6:41am    
;)
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Script component transformation SSIS
Syntax error in field definition SSIS
Assign a expression SQL result to a variable in SSIS
Foreach excel file in SSIS is not working
ssis ole db source(sql command from varaible)
Error SSIS Excel Source - connection manager incorrect type
Best source code editor component?
How to run an SSIS package having excel source on a server where excel is not installed using SQL Server Agent Job
SSIS - load data from informix source to sql server source
Creating Dynamic Excel in SSIS

Advertise
Privacy
Cookies
Terms of Use
Last Updated 20 Feb 2014
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web01 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900