Martin Schoombee

Forum Replies Created

Viewing 15 posts - 751 through 765 (of 893 total)

RE: Excel Sheet Erro

As far as I know, "Isnull" is not a valid Excel function so it cannot be used in queries against an Excel connection.
You would be better off extracting all the...

November 2, 2011 at 11:28 am

#1402307
RE: Separating SSIS and SQL Server in Production Environment

I tend to agree with Elliott on this one.
If you separate SSIS from the SQL Server instance, there are definitely a few trade-offs which in my opinion is not always...

October 28, 2011 at 2:17 pm

#1400786
RE: Smoothest way to go about this...

David Lester (10/26/2011)
You do have the right idea. One to One for all but a single client, whom is one to many. While there is no guarantee this will...

October 26, 2011 at 11:12 am

#1399803
RE: Smoothest way to go about this...

David Lester (10/26/2011)
I have a warehouse where there is a product code field, and this is 99% of the time queried for a single product code, which matches to a...

October 26, 2011 at 10:57 am

#1399791
RE: How to Develop report with Parent-Child relationship from Relational DB

Hi,
How about using a recursive cte?
Read up about it in BOL...that should work.
Martin.

October 25, 2011 at 10:54 am

#1399233
RE: Exporting a column that contains CSV data

Jeff Moden (10/21/2011)
I could be wrong but I believe the OP wants 1 "duplicated" row for each element in the CSV column.
Wasn't sure myself, but thought I would give the...

October 21, 2011 at 11:30 am

#1398146
RE: incremental load from oracle source..

skanth (10/21/2011)
there is bunch of errors
use of sql command from variable method also throws errors
how to handle the situation
Hi,
Oracle sources are a little tricky to...

October 21, 2011 at 8:49 am

#1398025
RE: Exporting a column that contains CSV data

jasonkellington (10/20/2011)
Any ideas of how to approach this?
First off, I'm not sure how to translate the original gaurdians column into separate columns in the csv, which is the biggest...

October 21, 2011 at 8:05 am

#1397986
RE: Report item expressions can only refer to other report items

abbysql (10/7/2011)
Yes, I tried that too, its giving me the same errors and not able to deploy the reports due to that errors. .......
Indeed it is interesting. I am also...

October 8, 2011 at 5:49 am

#1392043
RE: Report item expressions can only refer to other report items

abbysql (10/7/2011)
Data Source is basically the same. The Stored Procedures used to be always on SERVER B, and from SERVER A it used to access the Stored Procedures on SERVER...

October 7, 2011 at 4:09 pm

#1391999
RE: From SQL Server to Oracle using SSIS - Unicode issue.

Duran (10/6/2011)
Hello, I hope someone with more experience can help.
I am trying to use SSIS to move non unicode data into an Oracle database where it will stay as non...

October 6, 2011 at 10:18 am

#1391302
RE: Report item expressions can only refer to other report items

abbysql (10/5/2011)
Can someone resolve this issue for me pleasee
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/15169a60-a783-429c-95b6-d004dd6d2d42
Are there any differences between the source queries (probably stored procs...I hope) on the two servers?

October 5, 2011 at 11:52 am

#1390866
RE: SSRS 2005 - Splitting excel sheets while export a report

visual.prabu (10/4/2011)
Thanks. It works.
Sure, no problem.

October 4, 2011 at 7:22 am

#1390121
RE: Stored procedure return but report takes long time

Juls-195136 (9/30/2011)
Hi,
I have a fairly simple report that runs from stored procedure. When I execute stored proc with certain parameters it takes 19 seconds to return results. When I execute...

September 30, 2011 at 1:52 pm

#1389014
RE: SSRS 2005 - Splitting excel sheets while export a report

visual.prabu (9/29/2011)
Hi All
I have a RDL with details with 5 regions.
It all details come in a single sheet while i export to excel.
I have to specify each sheet for each...

September 30, 2011 at 1:48 pm

#1389012

Viewing 15 posts - 751 through 765 (of 893 total)