Need suggestions on text file parsing into database

I have a website, where people upload tab delimited text files of their product inventories, which the site parses and inserts into a database table. Here's the catch: Instead of insisting that each user use a standardized format, each user can upload the file in whatever column order they want, they just have to let the site know through a GUI which column is in which order. And, they may upload columns that if not mapped, will be ignored. Right now, I am doing all of this in code and it runs slow, I was thinking of offloading this to either a stored procedure, ssis, or bulk upload. But, with the varying format of the uploaded text file, I am not sure how I could do that. Any suggestions?

Thanks!

Hi keggdirdle,

As far as I can see, we cannot make the database recognize tab delimited text files automatically.

Whatever technology you use (stored procedure, ssis, or bulk upload), they all depends on fixed format for data.

In this case, I don't think it is possible without your own code.

Need SQL Server 2005 tool similar to Oracle's Connection Manager

I would like to know if there is a comparable tool in SQL Server 2005 to the
Oracle Connection Manager (link to Overview on Oracle product below)
http://www.oracle.com/technology/products/oraclenet/htdocs/cman_overview.htm
Hi
"Jason" wrote:

> I would like to know if there is a comparable tool in SQL Server 2005 to the
> Oracle Connection Manager (link to Overview on Oracle product below)
> http://www.oracle.com/technology/products/oraclenet/htdocs/cman_overview.htm
>
Apart from connection pooling I don't know of any third party product that
does anything like this.
For example see http://msdn2.microsoft.com/en-us/library/ms716319.aspx
John
sql

Need SQL Server 2005 tool similar to Oracle's Connection Manager

I would like to know if there is a comparable tool in SQL Server 2005 to the
Oracle Connection Manager (link to Overview on Oracle product below)
http://www.oracle.com/technology/pr...an_overview.htmHi
"Jason" wrote:

> I would like to know if there is a comparable tool in SQL Server 2005 to t
he
> Oracle Connection Manager (link to Overview on Oracle product below)
> Apart from connection pooling I don't know of any third party product thatdoes anything like this.For example see [url]http://msdn2.microsoft.com/en-us/library/ms716319.aspx" target="_blank">http://www.oracle.com/technology/pr...y/ms716319.aspx
John

Need SQL Server 2005 tool similar to Oracle's Connection Manager

I would like to know if there is a comparable tool in SQL Server 2005 to the
Oracle Connection Manager (link to Overview on Oracle product below)
http://www.oracle.com/technology/products/oraclenet/htdocs/cman_overview.htmHi
"Jason" wrote:
> I would like to know if there is a comparable tool in SQL Server 2005 to the
> Oracle Connection Manager (link to Overview on Oracle product below)
> http://www.oracle.com/technology/products/oraclenet/htdocs/cman_overview.htm
>
Apart from connection pooling I don't know of any third party product that
does anything like this.
For example see http://msdn2.microsoft.com/en-us/library/ms716319.aspx
John

Need recommendation on simple auditing product.

(SQL Server 2000, SP3a)
Hello all!
A while ago (2 years?) I downloaded a freeware auditing utility called SQLLog:
http://www.rlpsoftware.com/SQLLog.asp
It doesn't appear as if the freeware version is available from this site any more, so I
was hoping to solicit some opinions on a similar utility that would help audit database
deletions.
That old SQLLog utility basically put triggers on the desired tables, and squirted XML
into a blob field that would enumerate the fields and their original contents and any
changed data. It was pretty straightforward and simple to integrate with an existing
database.
If anyone knows of anything that might be applicable, I'd sure be grateful!
John Peterson
I've used SQLAudit and it works well. It basically places triggers on the
tables for you.
SQLAudit
http://www.redmatrix.com/default.asp?section=sqlaudit
I've heard good reports on Lumigent Entegra, but I haven't evaluated that
yet - it's on my to-do list!
http://www.lumigent.com/products/entegra/entegra.htm
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23gxhuLLKEHA.2456@.TK2MSFTNGP12.phx.gbl...
> (SQL Server 2000, SP3a)
> Hello all!
> A while ago (2 years?) I downloaded a freeware auditing utility called
SQLLog:
> http://www.rlpsoftware.com/SQLLog.asp
> It doesn't appear as if the freeware version is available from this site
any more, so I
> was hoping to solicit some opinions on a similar utility that would help
audit database
> deletions.
> That old SQLLog utility basically put triggers on the desired tables, and
squirted XML
> into a blob field that would enumerate the fields and their original
contents and any
> changed data. It was pretty straightforward and simple to integrate with
an existing
> database.
> If anyone knows of anything that might be applicable, I'd sure be
grateful!
> John Peterson
>
|||Thanks for the reply, Mark! I was checking out ApexSQL Log as well -- so this will be
nice to be able to compare/contrast. I see that Apex's solutions work by reading the
transaction log -- so no additional triggers need be in place. That seems like a pretty
clean solution.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:urpHFLQKEHA.1264@.TK2MSFTNGP12.phx.gbl...
> I've used SQLAudit and it works well. It basically places triggers on the
> tables for you.
> SQLAudit
> http://www.redmatrix.com/default.asp?section=sqlaudit
> I've heard good reports on Lumigent Entegra, but I haven't evaluated that
> yet - it's on my to-do list!
> http://www.lumigent.com/products/entegra/entegra.htm
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:%23gxhuLLKEHA.2456@.TK2MSFTNGP12.phx.gbl...
> SQLLog:
> any more, so I
> audit database
> squirted XML
> contents and any
> an existing
> grateful!
>

Need recommendation on simple auditing product.

(SQL Server 2000, SP3a)
Hello all!
A while ago (2 years?) I downloaded a freeware auditing utility called SQLLog:
http://www.rlpsoftware.com/SQLLog.asp
It doesn't appear as if the freeware version is available from this site any more, so I
was hoping to solicit some opinions on a similar utility that would help audit database
deletions.
That old SQLLog utility basically put triggers on the desired tables, and squirted XML
into a blob field that would enumerate the fields and their original contents and any
changed data. It was pretty straightforward and simple to integrate with an existing
database.
If anyone knows of anything that might be applicable, I'd sure be grateful!
John PetersonI've used SQLAudit and it works well. It basically places triggers on the
tables for you.
SQLAudit
http://www.redmatrix.com/default.asp?section=sqlaudit
I've heard good reports on Lumigent Entegra, but I haven't evaluated that
yet - it's on my to-do list!
http://www.lumigent.com/products/entegra/entegra.htm
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23gxhuLLKEHA.2456@.TK2MSFTNGP12.phx.gbl...
> (SQL Server 2000, SP3a)
> Hello all!
> A while ago (2 years?) I downloaded a freeware auditing utility called
SQLLog:
> http://www.rlpsoftware.com/SQLLog.asp
> It doesn't appear as if the freeware version is available from this site
any more, so I
> was hoping to solicit some opinions on a similar utility that would help
audit database
> deletions.
> That old SQLLog utility basically put triggers on the desired tables, and
squirted XML
> into a blob field that would enumerate the fields and their original
contents and any
> changed data. It was pretty straightforward and simple to integrate with
an existing
> database.
> If anyone knows of anything that might be applicable, I'd sure be
grateful!
> John Peterson
>|||Thanks for the reply, Mark! I was checking out ApexSQL Log as well -- so this will be
nice to be able to compare/contrast. I see that Apex's solutions work by reading the
transaction log -- so no additional triggers need be in place. That seems like a pretty
clean solution.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:urpHFLQKEHA.1264@.TK2MSFTNGP12.phx.gbl...
> I've used SQLAudit and it works well. It basically places triggers on the
> tables for you.
> SQLAudit
> http://www.redmatrix.com/default.asp?section=sqlaudit
> I've heard good reports on Lumigent Entegra, but I haven't evaluated that
> yet - it's on my to-do list!
> http://www.lumigent.com/products/entegra/entegra.htm
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:%23gxhuLLKEHA.2456@.TK2MSFTNGP12.phx.gbl...
> > (SQL Server 2000, SP3a)
> >
> > Hello all!
> >
> > A while ago (2 years?) I downloaded a freeware auditing utility called
> SQLLog:
> >
> > http://www.rlpsoftware.com/SQLLog.asp
> >
> > It doesn't appear as if the freeware version is available from this site
> any more, so I
> > was hoping to solicit some opinions on a similar utility that would help
> audit database
> > deletions.
> >
> > That old SQLLog utility basically put triggers on the desired tables, and
> squirted XML
> > into a blob field that would enumerate the fields and their original
> contents and any
> > changed data. It was pretty straightforward and simple to integrate with
> an existing
> > database.
> >
> > If anyone knows of anything that might be applicable, I'd sure be
> grateful!
> >
> > John Peterson
> >
> >
>

Need recommendation on simple auditing product.

(SQL Server 2000, SP3a)
Hello all!
A while ago (2 years?) I downloaded a freeware auditing utility called SQLLo
g:
http://www.rlpsoftware.com/SQLLog.asp
It doesn't appear as if the freeware version is available from this site any
more, so I
was hoping to solicit some opinions on a similar utility that would help aud
it database
deletions.
That old SQLLog utility basically put triggers on the desired tables, and sq
uirted XML
into a blob field that would enumerate the fields and their original content
s and any
changed data. It was pretty straightforward and simple to integrate with an
existing
database.
If anyone knows of anything that might be applicable, I'd sure be grateful!
John PetersonI've used SQLAudit and it works well. It basically places triggers on the
tables for you.
SQLAudit
http://www.redmatrix.com/default.asp?section=sqlaudit
I've heard good reports on Lumigent Entegra, but I haven't evaluated that
yet - it's on my to-do list!
http://www.lumigent.com/products/entegra/entegra.htm
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23gxhuLLKEHA.2456@.TK2MSFTNGP12.phx.gbl...
> (SQL Server 2000, SP3a)
> Hello all!
> A while ago (2 years?) I downloaded a freeware auditing utility called
SQLLog:
> http://www.rlpsoftware.com/SQLLog.asp
> It doesn't appear as if the freeware version is available from this site
any more, so I
> was hoping to solicit some opinions on a similar utility that would help
audit database
> deletions.
> That old SQLLog utility basically put triggers on the desired tables, and
squirted XML
> into a blob field that would enumerate the fields and their original
contents and any
> changed data. It was pretty straightforward and simple to integrate with
an existing
> database.
> If anyone knows of anything that might be applicable, I'd sure be
grateful!
> John Peterson
>|||Thanks for the reply, Mark! I was checking out ApexSQL Log as well -- so th
is will be
nice to be able to compare/contrast. I see that Apex's solutions work by re
ading the
transaction log -- so no additional triggers need be in place. That seems l
ike a pretty
clean solution.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:urpHFLQKEHA.1264@.TK2MSFTNGP12.phx.gbl...
> I've used SQLAudit and it works well. It basically places triggers on the
> tables for you.
> SQLAudit
> http://www.redmatrix.com/default.asp?section=sqlaudit
> I've heard good reports on Lumigent Entegra, but I haven't evaluated that
> yet - it's on my to-do list!
> http://www.lumigent.com/products/entegra/entegra.htm
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:%23gxhuLLKEHA.2456@.TK2MSFTNGP12.phx.gbl...
> SQLLog:
> any more, so I
> audit database
> squirted XML
> contents and any
> an existing
> grateful!
>