Its really a strange World over in....

...the Access forum...so many bad practices
Like this one
http://www.dbforums.com/showthread.php?p=6284279&posted=1#post6284279I have had my fill of discouragement today, so I am not following the thread but what do you expect from people who work with PlaySkool's "My First Database Engine". Admittedly, it's been a couple of versions of Office since I have dealt with a lot of that crap but I can not imagine it has gotten a lot better nor the average Access practitioner has become that much more of a sophisticated programmer.|||the average Access practitioner has become that much more of a sophisticated programmer.

pfffffffffffftttt...sophisticated?

Scrub, more likely|||...the Access forum...so many bad practices

Like this one

http://www.dbforums.com/showthread.php?p=6284279&posted=1#post6284279
Could be worse. Could be Excel. Remember the spat I got into the with Excel developer who insisted that spreadsheets were equal to or superior to databases?|||No. I think I missed that one.|||After reading that thread I think I am going to go sit in the corner and cry.|||I know how much you guys bash Access - but that's how I started!
I still enjoy using it for small scale stuff.

I would not be the developer I am today without Access.|||I think Access is a great product. The problems occur when it is used beyond its capacity.|||Yeah, hell, I did a boat load of Access...it's not Access

It's like giving a loaded gun to a monkey however

And the Excel thing, I'm in the middle of convert a "system" to .net and SQL

One of the things they like to do, is cell reference, where that's more difficult to reference rows to each other

However, what I find is that a lot of it can be handled with math, which the excel "programmers" never take the time to investigate

Ask an excel "programmer" to do a set based running total

fuuuuget about it|||Should this not be in chat?|||It's a really strange world when the Sybas^H^H^H^H^HSQL Server guys are busting on Access guys...

I happen to like SQL Server. Most of my work I've done on SQL Server. But let's be honest: better adherence to the SQL standard just means it's more standard, not that it's more relationally correct. And given that most client apps written for SQL Server are done in Visual Basic, you can hardly get all uppity about your choice of imperative languages.

BTW, Kaiser, why are you criticizing them for utilizing a progress bar? Every human interface guideline I've ever seen, from the original Macintosh HIG manuals to the Windows guidelines, states that if a long task is running that the system should display a progress bar. Where's the bad practice here?|||Oh, my dear sco08y

What makes you think a batch process should have the user sit there and watch?

It is a culture of bs m$ crap, that's what

Any process that is not in the milliseconds should be a background asynchronous task

better adherence to the SQL standard just means it's more standard, not that it's more relationally correct.

"Any Response to that"

"Yeah: WHAT?"|||Any process that is not in the milliseconds should be a background asynchronous task

Yeah, that's what the minimize button is for. But I see what you're getting at, and it's really due to deficiencies in the OS.

Besides, even the so-called server operating systems like Unix require a lot of babysitting of background tasks. And I've never seen a good UI for sifting through log files.

Issue Loading Data from Flat File

I have come across a strange bug that I can't get to the bottom of.

I have a source Excel spreadsheet with approx 30000 rows in it, I have saved this out using Excel 2003 as a csv file which contains all of the source rows.

Using a Flat File Source I am only getting approx 15000 rows through, I have re-saved the spreadsheet as csv and it stops at exactly the same point. However, if I use the excel spreadsheet as the source I get all 30000 rows.

I have checked the CSV at the relevant point and can see no reason why it would stop at that particular point.

I am experiencing a similar problem with another source file handled in exactly the same way.

Has anyone else experienced this?

Philip

UPDATE: looks like this could be a problem in Excel, Used a Excel Data source and a Flat File Destination to create the CSV, and my original Data flow now uses all the data

Philip Coupar wrote:

I have come across a strange bug that I can't get to the bottom of.

I have a source Excel spreadsheet with approx 30000 rows in it, I have saved this out using Excel 2003 as a csv file which contains all of the source rows.

Using a Flat File Source I am only getting approx 15000 rows through, I have re-saved the spreadsheet as csv and it stops at exactly the same point. However, if I use the excel spreadsheet as the source I get all 30000 rows.

I have checked the CSV at the relevant point and can see no reason why it would stop at that particular point.

I am experiencing a similar problem with another source file handled in exactly the same way.

Has anyone else experienced this?

Philip

UPDATE: looks like this could be a problem in Excel, Used a Excel Data source and a Flat File Destination to create the CSV, and my original Data flow now uses all the data

I'm working with Philip on this. Basically it looks as though there's problem in the way that Excel saves stuff to csv. Anyone know why?

-Jamie

|||

We are experiencing the same exact problem. The CSV file imports fine using our old DTS Packages just not with the new SSIS packages we have created. I can provide sample csv files if needed.

If you have an update on this, please let me know.

|||Did you see the workaround that Philip posted (above)?

-Jamie