Closed

File Import and Database Insert / Export

I need a .Net v2.0 [url removed, login to view] app that uses SQL Server database and SSRS Reports.

I am looking to take a tab-delimited file, importing it using this new app, and break the data out into separate tables, and build a report out of it's contents, complete with sort options, searching through the imported records.

I have an excel spreadsheet that includes all of the master table value information as well as sample data, file layout specs, etc.

A few fields (Columns) of data include multiple value separators, including ~ and |, that need to be separated out and delimited by ,'s.

If a row cannot be imported, we need to know what is messing up the file at the row level and if possible, the column level.

After this data has been entered into the SQL warehouse you create with a column value for a practice (and maintaining perfect referential integrity), it needs to be able to export into three separate txt files, tab delimited.

Option to catch exceptions and edit on the fly must be possible.

Sample files will be provided.

Specs will be provided.

Delivery must include:

SQL database objects, including tables, SPs, and any other objects suitable in a SQL 2005 environment.

SSRS report that has query fields, etc., for drilling down on various types of referential data, groupings, etc.

Skills: Software Architecture, SQL, Visual Basic

See more: ssrs import tab delimited file, types of searching in c, new spreadsheet app, ssrs, ssrs sql, ssrs report, sql database report, sps, import database, Import and export, excel with sql server, drilling, build database sql, excel database visual basic, insert multiple records, multiple warehouse, app basic excel, create sql report, visual basic database excel database, net excel import, net import export, sample visual basic excel, insert txt, sql report edit

About the Employer:
( 8 reviews ) Wilkes-Barre, United States

Project ID: #4523150

21 freelancers are bidding on average $540 for this job

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$257 USD in 5 days
(35 Reviews)
6.6
eperfections

Hi, I am interested in this project. Read your requirements carefully. Experienced programmer with 500+ reviews. Please consider my proposal.

$526 USD in 7 days
(119 Reviews)
6.4
ITservice

Hi Ready to start. Regards

$515 USD in 10 days
(16 Reviews)
5.6
samitXI

Please check your inbox. Thanks

$608 USD in 7 days
(22 Reviews)
5.4
dobreiiita

Hi, I can help you.

$699 USD in 12 days
(61 Reviews)
5.3
MMaghawry

I'm .net expert , so I can help u doing this project.

$252 USD in 3 days
(35 Reviews)
5.2
rajanlengde

Its a realy interesting project I will like to work on, please provide further details.

$947 USD in 30 days
(26 Reviews)
5.0
chetanraj81lx

I have excellent work exp. I can do this in c# or vb.net. Thanks

$744 USD in 7 days
(7 Reviews)
4.9
NinadPatil

Respected Sir, Thank you for your time to read my initial posting, I have read initial project description and wanted to discuss further. Please have a look at the private message. Thanks, Ninad Patil

$252 USD in 10 days
(15 Reviews)
4.8
diegogarcia0531

Hi, I can do the job, just provide full specs document I am looking forward to work with you again Regards Diego

$555 USD in 10 days
(21 Reviews)
4.7
farhaoui

HI, READY TO START WORK. LETS START AND FINISH IT ASAP. I HAVE 8 YEARS OF EXPERIENCE IN WEB DEVELOPMENT FIELD ( PHP, MYSQL, AJAX, JQUERY, HTML, CSS... ). THANK YOU !!

$515 USD in 3 days
(33 Reviews)
4.2
Pharoa

I will bring over 19 years of technical programming experience in VB and SQL Server to bear on your project should you elect to award the project to me . thanks for the opportunity to bid on your project.

$555 USD in 3 days
(3 Reviews)
3.8
sqlservercoder

This is Baskaran Selvaraj and have worked for various clients like Amway, Mellon Group for past 15 years as Database Administrator & Application developer. Achieved Microsoft Certifications in Microsoft SQL Serve More

$444 USD in 5 days
(3 Reviews)
2.4
ncrsoftwares

I can do this job.

$666 USD in 3 days
(3 Reviews)
0.9
pandyamunjal

Dear Sir, We are an IT firm from India, with a good experience on data-driven applications. We have been developing systems on Microsoft Platforms for both front-end and backend and would like to develop this app fo More

$555 USD in 10 days
(0 Reviews)
0.0
harishmehla

Sir if you are looking for SSIS and SSRS programmer then i can help you out. Because of client terms i can't public there project but if you ask for interview then i can show you projects, Crystal report server and SSR More

$555 USD in 30 days
(0 Reviews)
0.0
vw6776001vw

Hello! We have reviewed your project and this is something we have lots of experience with. I would like to offer you our services. Thank you!

$500 USD in 7 days
(0 Reviews)
0.0
ilianMad

HI, I've already done apps like this, I would complete and test the project the way you need.

$444 USD in 7 days
(0 Reviews)
0.0
Jedsman

I have created many applications that import and export data using vb & c# .net and SQL server. I have recently completed a similar project to this for Sony Europe.

$555 USD in 5 days
(0 Reviews)
0.0
miniric3

Hi, We at on2itonline would love to work with you on this, we do MAD "full service" websites on a clear and fixed budget. We have lots to offer that others don't ,like our lifetime FREE hosting on every website for a s More

$659 USD in 23 days
(0 Reviews)
0.0