-
as seen on SQL Blog
- Search for 'SQL Blog'
When you install SQL 2008 R2 workstation components you get a newer version of BIDS (BI Developer Studio, included in the workstation components) that replaces BIDS 2008 version (BIDS 2005 still live side-by-side). Everything would be good if you can use the newer version to edit any 2008 AND 2008R2…
>>> More
-
as seen on SQL Blog
- Search for 'SQL Blog'
Often when using SQL Server Integration Services (SSIS) you will find there is more than one way of accomplishing a task and that the most obvious method of doing so might not be the optimal one. In the video below I demonstrate this by way of an experiment using SSIS’s Flat File Source component;…
>>> More
-
as seen on SQL Blog
- Search for 'SQL Blog'
In recent blog posts I have introduced the new SSIS Catalog that is forthcoming in SQL Server Code-named Denali:
What's new in SSIS in Denali
Introduction to SSIS Projects in Denali
Parameters in SSIS In Denali
SSIS Server, Catalogs, Environments and Environment Variables in SSIS in Denali…
>>> More
-
as seen on SQLIS
- Search for 'SQLIS'
I stumbled across a new SSIS tool on Codeplex today, the SSIS Log Analyzer which was only released a few days ago. Whilst it is a beta release and currently only supports 2005 (2008 is promised) it looks quite interesting. It seems to be a fancy log viewer, but with some clever features and a nice…
>>> More
-
as seen on SQLIS
- Search for 'SQLIS'
I stumbled across a new SSIS tool on Codeplex today, the SSIS Log Analyzer which was only released a few days ago. Whilst it is a beta release and currently only supports 2005 (2008 is promised) it looks quite interesting. It seems to be a fancy log viewer, but with some clever features and a nice…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
This is from the DBD::File-documentation:
f_ext
This attribute is used for setting the file extension where (CSV) files are opened. There are several possibilities.
DBI:CSV:f_dir=data;f_ext=.csv
In this case, DBD::File will open only table.csv if both table.csv and table exist…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Here is my class,
public class FreebasePeopleResults {
public String intendedSearch;
public String weight;
public Double heightMeters;
public Integer age;
public String type;
public String parents;
public String profession;
public String alias;
public String children;
public String siblings;
public…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
What am I trying to do: export data to csv.
I have a form which allows user to select the format (from a drop down menu). So based on the selection of the format the ouput is displayed using a ajax call. Works fine for html but when I select the format as csv I don't see any pop up on the screen…
>>> More
-
as seen on Super User
- Search for 'Super User'
I have these 3 files
21/08/2014 07:15 PM 122 Tw2AWK.csv
21/08/2014 07:15 PM 125 Tw2Notepad.csv
21/08/2014 07:15 PM 119 Tw2REPL.csv
C:\myfilesfile Tw2AWK.csv TwREPL.csv Tw2Notepad.csv
Tw2AWK.csv; UTF-8 Unicode text, with CRLF line terminators
Tw2REPL…
>>> More
-
as seen on Super User
- Search for 'Super User'
My data:
It's a 71 MB file with 1.5 million rows.
It has 6 fields
All six fields combine to form a unique key - so that's what I need to sort on.
Sort statement:
sort -t ',' -k1,1 -k2,2 -k3,3 -k4,4 -k5,5 -k6,6 -o output.csv input.csv
The problem:
If I sort without keys, it takes 30 seconds…
>>> More
