Viewing 15 posts - 121 through 135 (of 279 total)
Thanks everyone for taking time and replying , this export to excel is not direct , i have check other tables and do lot of stuff to get this point...
October 5, 2016 at 9:19 am
the column is missing in "preview" of the report in ssrs .
October 5, 2016 at 9:15 am
the columns are overlapped in excel. so is there a way taht it is not overlapped while exporting to excel through ssis?
October 4, 2016 at 1:33 pm
the one with date and int. I am using dataconversion task and chanhing everything to dt_wstr ...
overlapped columns. is there a way they do not overlap?
October 4, 2016 at 1:09 pm
Source
[ItemID] [bigint] NULL
[State] [nvarchar](255)
[Trade Date] [date] NULL,
[invoice_id] [bigint] NULL,
Firstname Last Name ItemID E-mail Address Address 2 City State Zip invoice_id Trade Date Kit Type Required
komal jawal 3200011564 abcd@gmail.com 1234 berookdt APT 123 frisc dc 75345 2234355444444 2016-09-29 TGSAPmT01
October 4, 2016 at 1:00 pm
[Derived Column [24]] Error: An error occurred while attempting to perform data conversion. The source type could not be converted to the destination type.
I keep getting this error again and...
October 4, 2016 at 12:45 pm
how can i do that?
October 4, 2016 at 12:19 pm
Yes..there is data of date type , numeric too
October 4, 2016 at 12:13 pm
i want everything to string , so it just prints the columns to excel. I am using data conversion task , DT_str? or DT_WSTR?
little confused which to use.
October 4, 2016 at 12:12 pm
Is this expression written in textboxproperties -> Visibility-> hide expression?
I have written this expression in above mentioned place , when i do it preview it does not show columns but...
October 3, 2016 at 8:43 am
this has to be done by grouping and expression in ssrs . So , cannot use CTE.
Anyways i did resolve this by grouping.
October 2, 2016 at 10:16 pm
can you reply with your iff condition?
September 29, 2016 at 3:27 pm
Thank you. I got it resolved.
September 29, 2016 at 10:37 am
@luis:Thank you for reply . I tried your query and the result from your query is :Aug 10 2016 5:29AM .
Which is not what i want....
September 22, 2016 at 9:09 am
?? the table that has sendate is created by someone else , my table has datetime.
September 21, 2016 at 3:03 pm
Viewing 15 posts - 121 through 135 (of 279 total)