Viewing 15 posts - 151 through 165 (of 399 total)
Then my suspicion is that the scrubbing step is the culprit, have you tried to append a single empty line to the file after the scrub?
and yes, 2 days...
May 3, 2015 at 9:00 am
sorry, I don't know C#...
There should be no need to clean / replace the thorn character, just configure it as a delimiter for the source.
FF Source doesn't offer thorn as...
May 3, 2015 at 8:02 am
1) Import the file line by line into a staging table and parse it from there. This method is common when importing multi-document-type files.
The file uses...
May 2, 2015 at 9:24 pm
...
February 19, 2015 at 1:05 am
..
September 9, 2014 at 9:03 am
I'm not the one making the decisions regarding the infrastructure. My query writing for SSRS reports will spiral out of control the day I have to add linked server aliases...
September 5, 2014 at 8:19 am
Thanks Grant.
By extensible I mean, current practices that will allow maximum future flexibility to rearranging server and network infrastructure. For example, in the near future we may acquire new...
September 4, 2014 at 9:41 am
Quick question, does A query B and B query A where A and B reside on the same server, referencing the same linked server alias as the first of a...
September 3, 2014 at 7:51 pm
thinking about this further, I don't see evidence from my reading, that two different servers can't both point to the same third machine using the same linked server name.
Additionally, am...
September 3, 2014 at 3:35 pm
ChrisMhome. Performance comparison of linked query versus without is verified. Execution time is 2x longer with the linked query that brought me to this forum.
August 31, 2014 at 1:42 pm
hmmmmm.
August 31, 2014 at 1:37 pm
Now the DB_2 is moved to another server, SRV_B, the LSRV_A would have to be changed to point to SRV_B etc.,
Yes, and that's his point. That if a lot of...
August 31, 2014 at 12:39 pm
Clarification of your answer please.
If there are 2 servers whose databases are linking to a 3rd server's database, do each of the 2 server's linked server names have to be...
August 31, 2014 at 11:21 am
Finally:
The filter expressions are as follows:
current year
=year(today)
last year
=year(today)-1
year before
=year(today)-2
I now have 3 tables, each showing a different year of data in the same report.
:sick: I nearly died, but...
August 28, 2014 at 7:17 am
I am grouping each table on move_date (date time stamp).
Group properties group expression:
=Year(Fields!move_date.Value)
That part works but each table groups data by 2014, 2013, 2012.
Will you please show me the...
August 28, 2014 at 7:04 am
Viewing 15 posts - 151 through 165 (of 399 total)