i want nest condition
here i have mentioned two columns in frompremise and topremise
frompremise=top remise means display 'b'
frompremise= odd value means display 'o'
frompremise=eve n value means display 'e'
please quick reply for me
this condition i have used in ssis derived column
mmabdulkadir
Last Activity: Jan 24 '12, 12:15 PM
Joined: Jan 3 '12
Location:
-
ssis derived column
-
this is syntax for order by and distinct
Code:select distinct columnname from tablename order by columnname asc/desc group by columnname
-
ahamed, here u had used in group by clause because where it is aggregate function is used that only. group by clause is what are columns are selected the table using select clause that all the columns are used in group by clause except the aggregate function columns.Leave a comment:
-
ssis derived column
i am used in ssis 2008.
i had worked the ssis 2008... i want convert the float to string in derived column transformation. in this transformation convert() is not available. so how to covert. anyone answer for my questions. -
thanks rabbit. i will check it..Leave a comment:
-
SSIS send mail task
i had worked the ssis 2008 in send mail task.
this errors coming. what is the solution for this error any one help me.....
error details----
[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.
System.Net.WebE xception: The remote name could not be resolved: 'SMTPServerName '". -
how to convert the unicode string to four byte signed integer
now i have worked in ssis 2008 BI concepts.
how to convert the unicode string to four byte signed integer.
waiting for reply.
No activity results to display
Leave a comment: