Закрыт

SSIS and Stored Procedures to export to XLSX and Geocoding

Create generic packages so that data/tables can be used by anyone.

SSIS Package #1:

Loop through options for each group id , group name in stored Proc or table

Get data from the loop

populate template xlsx file

Reformat it (template includes data tab , and two pivots that should be auto populated).

Save with specific names based on group id , group name from above plus date

go to next groupid , groupname in the list until done.

Create job script to execute ssis and create email from job as HTML.

notify users that the file is available now in the directory specified.

SSIS Package #2:

Have a loop similar to #1

export file using [login to view URL]

open source free tool to create xlsx files.

During loop:

get data , create initial page with raw data , second sheet with pivot chart , third sheet with graphs.

save with specific name as above with date.

SIS Package #3

Create Google and Bing Geolocation API that will map Customer database with unique id, address, city , state , zip USA only.

Which will output all of the input table plus longitude and latitude and status if nothing is found.

Ex:

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

SQL Stored Procedure :

Similar to #3 but it will take input address and list of other addresses from database and provide output of distance in Miles between those addresses.

Квалификация: .NET, SQL, SSIS (SQL Server Integration Services), VB.NET

Показать больше stored procedures business rules, schemas stored procedures, sql server 2005 stored procedures, flat file source to excel destination in ssis, ssis excel destination sql command, ssis excel destination create new file, export data from sql server to excel using ssis, ssis export to xlsx, export stored procedure output to excel, ssis package to export data to excel and send email, ssis export to excel template, SQL Stored Procedures, mssql 2008 stored procedures, sybase perl stored procedures dblib, convert sql stored procedure oracle stored procedures, mssql stored procedures zip radius, sql 2005 stored procedures, oracle sql 2005 stored procedures, stored procedures work sql, copy stored procedures sql

О работодателе:
( 47 отзыв(-а, -ов) ) Northridge, United States

ID проекта: #19145931

9 фрилансеров(-а) в среднем готовы выполнить эту работу за $100

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Больше

$150 USD за 3 дней(-я)
(14 отзывов(-а))
5.5
sreenivas2903

Hi. I would like to develop and full fill ur requirements exactly what u requested ping me if u are interested

$155 USD за 5 дней(-я)
(12 отзывов(-а))
4.0
jayantavkumar

Solution - Using SSIS ETL, your process will be fully automated... I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Больше

$166 USD за 3 дней(-я)
(3 отзывов(-а))
3.0
avinpanwar300

Hello , Greetings !!! I just read your Project Description and i m willing to go ahead and start Development on this Project SSIS project for Different source . I have done this kind of project recently i can Больше

$25 USD за 1 день
(2 отзывов(-а))
1.1
evonsystems7

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si Больше

$34 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
VishalAgrawal11

Hi,I have read your requirements of SSIS and Stored Procedures to export to XLSX and Geocoding and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude. I am v Больше

$24 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
sagom

I'm a software engineer with a postgraduate in software development and I have extensive experience in the development of web and mobile software, I have worked with business intelligence projects based on Microsoft te Больше

$111 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
vdashu

Hello, I have 11 year experience in SQL, SSIS , Informatica. I can develop exactly you need . please ping me if interested. working in banking domain company using same technologies and working as a freelancer as wel Больше

$111 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
tanajisulagave31

Hi I have good knowledge about SSIS technology. now working on SSIS technology in one company in india since 3 year.

$127 USD за 7 дней(-я)
(0 отзывов(-а))
0.0