I was afraid that would be the answer, we can’t edit the files manually, the files arrive once a week and can have upwards of 50K records.
And writing the app will work, but it increases our overall processing time and we have a very strict turn around when it comes to the client’s files. If there is no way to handle this data properly when it gets this problem then we will have to let the client know it’s bad data and hope they...
Javilen
Last Activity: Dec 10 '08, 02:24 PM
Joined: Sep 19 '07
Location:
-
Sax Content Handler in VB6 and the "&" symbol
At my company we use the Sax Content Handler to parse XML data files.
We are running into a problem where the client is some times sending an & with out the accompanying amp; example. They send <Client Name> AT&T</client Name>
The Sax crashes between two functions it seems and we can’t seem to find a way to catch the error before it happens to try and avoid it.
Has anyone come across this and... -
Closing a window when the parent is closed or exited.
Hello,
I am having trouble getting what should be simple to work.
On my site we display peoples bills, we link to the companies website when viewing a specific link, this si done by passing the variables through a post/submit, the code is below.
...Code:<form name="frmBill" method="post" target="_SELF" action="www.someURL.com /printbill.do" onSubmit="Billing = window.op
-
checking for proper double
I have an app where people scan orders in and we pull all the details, they then confirm and correct details that scanned incorrectly.
One field is price, what the client is starting to do is enter invalid prices, for example today they entered “.” And that’s it, which crashes a back end app that converts the xml to EDI and sends it to the supplier.
I would like to put in some checks that will do something like... -
For the interested people.
We installed the integrated Services onto the server and then remote desk topped into the machine and logged in as the DB owner.
We created the package from scratch and the job under this login.
When we ran the job it worked without error.
ThanksLeave a comment:
-
The product level is insufficient for component "Data Conversion 1" (117)
Hello,
edit: added some more info
I am trying to set up a job to run a SSIS package in SQL 2005, the SQL 2005 is installed on a Windows server 2003 machine.
start Edit
I have the Management studio (I am working from) installed on windows XP (fully up today with the SPs). I have the installed on this machine the integrated Services, I do not know if they have been installed on the Windows 2003 machine... -
Working with DTS
Hello,
I am trying to setup a DTS package that pulls the contents from a table and places it into an access table.
Part 1:
When I save it on the sql and set it up to be scheduled I get the below error.
The owner of the package has the proper rights to run it, and the SQL Server Agent that actually executes the document has System Admin rights.
If you have... -
Hey,
That is exactly what we needed, I implemented it and found immediately a decrease in the Deadlocking.
I also think that just the changes this made for the main page will have a residual effect through out the rest of the site which is nice.
We will be running it like this for a week to monitor the actual improvements but I wanted to thank you for the answer you gave as it seems to have worked wonderfully....Leave a comment:
-
Optimized query
Hello,
I am looking for some Query Optimization help,
We are running a web application that is growing experientially in traffic and we are not running into Problems with Deadlocks on the SQL database.
After analyzing the logs 90% of our deadlocks happen from the main login page(the page hit after login)
This page doubles as the first page you see and as the main work area.
... -
Dynamic dropdown suggestion list on key press, 1 million possible results.
Hello,
Maybe one of you can offer a possible solution to the problem I have below.
The request to me is to build a dynamically populating dropdown list from a text box.(something similar to Google Suggest.)
The idea is that the client wants to come in and search for something but may only know part of the name. So they type it in.
Eg. Egg
The list generates after each letter... -
Request.querystring fun
Hello,
I am developing a forums for asp.net, in doing this I am using code behind to do all validation on users and roles and then using embedded ASP to do the displaying for categories, sections and threads!
The problem I am having is, when you first navigate to the site you pass the forum name in a querystring. So foe example: forumid=testfor um
I do this because the site will host multiple forums and... -
I solved it on my own, I removed the vb.net programming and used the DTS built into sql to export the table I wanted based on the fields I wanted to the access DB. The DTS has a scheduling option that allowed me to schedule the process to run 1 a week when I wanted.
ThanksLeave a comment:
-
Sql 2000 into Access db 2000 using vb.net
Hello,
I am trying to right an application that will dump the information from an sql server 2000 into Access 2000 via VB.net
The gist is, we have 1 table in sql 2000, it has 5 columns and 15 rows of data, one of the columns is a date that holds the info of when the record was added.
I want to select all rows that have a date between X and X and then dump them, in there entirety into an Access DB that... -
It's a good idea, and I think I can use it to break my groups down into 1100 parts, but if there is a way to just take the first file found and work with it I would prefer this....Leave a comment:
-
list the first file name in a directory vb.net 2005
Hello,
I have a directory with 26,500 files in it.
I need to parse each of these files and rename them.
To rename them I need to compare some parts of each file name to a look up table, take a value from the look up table and combine it with another part of the file name for the new file name.
Normally I would simply do the below:
...Code:Dim files() As String = Directory.GetFi
-
Thanks for the help, I will try your way out.Leave a comment:
-
Dumping CSV file into a Array in vb.net 2005
Hello,
I want to place the contents of a CSV file into an array.
The csv file looks as follows:
CG.A1300.CB24.K REG176E,BEYYMMD D
CG.A1300.CB24.K REG176F,BFYYMMD D
CG.A1300.CB24.K REG90,BBYYMMDD
CG.A1300.CB24.K RG8183E,BDYYMMD D
CG.A1300.CB24.K PRODCON.RPT,BRY YMMDD
I want to put this into an array, but I need it to be split on the Comma so that the final result is the... -
In case anyone is interested I figured it out, thanks for the help, but in the end the answer was way easier then the question, and the simple complexity of the question leads everyone who I had look at it to a much more complicated answer. Below is the solution I cam upon my self, witch works flawlessly.
...Code:SELECT avg(convert(Decimal,CHARACC)) as Characc_avg, --ERROR Type sum(case when Errtype='FE' then 1 else 0 END )
Leave a comment:
-
Thanks for the help, below is what I have placed but I get the following error:
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near ')'.
SELECT max(CharAcc_avg ), max(TE_Count)
FROM (
SELECT avg(CharAcc) as [CharAcc_Avg], NULL as [Errortype]
FROM document
UNION
SELECT NULL as [CharAcc_Avg], sum(case when Errortype='TE' then 1 else 0 END ) as [TE_Count]...Leave a comment:
-
Summarizing multiple items at once
Hello,
I was hoping someone here can help me out.
The Scenario is this:
We have an application here that produces general reports for our product, displays items received, the amount of error on the item, how many pages it is, the type of errors the stage in the process it’s at and the flag it’s been set to. As well as the accuracy. (there is more but these are the relative items.
Currently...
No activity results to display
Leave a comment: