CSV data import into SQL server - including typecasting

Hi I have been working with MSSQL for over 15 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

Hello, I am very much interested to do this work as i have strong knowledge in SQL server related task. I have done similar type of work using C# and SP. Looking forward to have a positive response from you. Thanks

Hi Sir/Madam. Ready to start. Thanks. Our slogan :  ** What we do, you can find elsewhere ** ** How we do it, makes all the difference **

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 6+ years of experience in Web Development. I have worked on below technologies/languages/database server. - Asp.net,C#.net,Asp.net MVC - Linq to SQL,Entity Framework - Javascript,Jquery,KnockoutJS,AngularJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Facebook Graph API - Application Security Remediation - SVN,TFS I love working on SQL and query/sp optimization . I can achieve the results that you are asking for. We can discuss further on chat(Skype:mahajan344). Looking forward from your end. Thanks Nikhil Mahajan

Hello, you want to execute the sp and import the data into a database, right? Approximately how many records contain the csv file? You can explain what the calculations required to import You can explain what the calculations required to do after import? Please talk to the chat for details About me I am a web developer focused on Microsoft technologies, I worked about 4 years developing web applications built using Asp.net and SQL Server 2005, 2008 and 2012.

A proposal has not yet been provided

hello buddy i will do it i am sql programmer an i am doing this job in my software company since 2012 i have vast industry expereince

A proposal has not yet been provided

Hi, I would like to work on your SQL project. Please take a look at my profile and message me. Thank You.

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end.

I can give you the usable script in a couple of hours .Have done numerous similar work in the past and team has vast experience in creating stored procedures,cursors etc.

Hello, As far as we have understood by the description, you want to import the files from csv to db and it gets automatically converted to desired types. Which we didn't understand clearly is the last part, the imported files will be used to calculate with the existing files in db or something else, please clarify this part. Please get in touch for any information or queries. Regards, OKTeam

A proposal has not yet been provided

Hey Pascal . I am ready to begin working on the project right away. Please share details so I may take a look. Thank you. Usman

A proposal has not yet been provided

Hello, i have checked your project and would like to have your project. I am confident to fulfill your requirements in timely manner, along with quality work. Please check your pmb.

Hi, I have worked on number of imports and exports of this kind, I have good experience in importing and exporting data from CSV files into SQL Server. I understand that you need to import and load CSV into an existing data table and format the data types as per the underlying table definition. I can do this CSV import via 1) SQL stored procedure 2) or SQL script 3) or can automate this using SSIS package or import export wizard I can even optimize the import for performance. Regarding my experience, I have 5+ years of experience on SQL Server platform and have MCSA certification. Please don't hesitate to contact me anytime and Kindly let me know if you need any further information about my approach. Thanks

i read your requirement.i had develop more than 300 website projects. i will show my portfolio to you

Hello Sir, i have got experience of importing csv data to sql server. I can do this job easily. Thanks. _

A proposal has not yet been provided

Aucune proposition n'a encore été fournie.