build SSIS package

$8-15 USD / hour

Completed

Posted

about 10 years ago

$8-15 USD / hour

Need a small package built that allows us to bring in an excel-based data set that is sent to us every month. Ultimately the dataset needs to be imported into a Microsoft SQL relational table. Some transformations include: ignoring a fixed number of rows in the beginning of the excel record set as well as the last record in the excel record set. rename column names manipulating the data types so that values do not show up in exponential notation and are not missing leading 0 values such as for zip code columns. We would like the package to dynamically create the table name each time the package is run. Ideally, we would like the package to listen for files within a target folder so we do not have to rename the file each time we want to run the package.

Database Administration

Excel

SQL

Project ID: 5789761

About the project

7 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@Dilkushp

Hi, I'm a SSIS SME working Micrsooft Support team who takes care of SQL BI stack. I'm with Microsoft for 2 years and working with SSIS for same amount of time. I have my MSDN blog which is [login to view URL] Also I have created one custom SSIS component which is available on codeplex. [login to view URL] I have dealt with this sort of requests and being in support have dealt with many more difficult ones and I'm sure that i can help you in finishing this work. Let me know if i can help. Thanks, Dilkush

$11 USD in 5 days

4.7

(2 reviews)

2.2

7 freelancers are bidding on average $14 USD/hour for this job

@abdellatif81

Hello Seriouslyskilled , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases(SSIS,SSAS,SSRS), i have more than 8 years in IT projects with 5 years working around database and BI projects . My last job was senior Microsoft BI consultant within Accenture ,for more than 4 years .I worked for several database and BI on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong experience in SQL Server databases and ETL projects with SSIS to develop all types of requirements related ,and given my experience i am persuaded to give you a High quality of work delivery withing budget and time. Best regards,

$24 USD in 20 days

4.9

(16 reviews)

5.2

@codedeveloperin

Hi, I have good experience in SSIS and completed 10+ projects successfully , Kindly consider me for this project. Thanks Raja

$15 USD in 3 days

4.9

(23 reviews)

4.7

@sherifamgadnabih

i am a software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck

$11 USD in 60 days

5.0

(3 reviews)

2.1

@decodeworld

We are interested in assisting you in completing your project as we have the experience that is needed. Thank you for reviewing our bid.

$12 USD in 30 days

0.0

(0 reviews)

0.0

@lads09

Hello, I will create a package for you. I have worked for SSIS in the past with transfer the data from the Access to SQL and this will be similar to that and also need some query to create the table. Also i need information about which SQL server you are using so based on that i can create package in 2008 or 2010. Looking forward to your positive reply. thanks, lads09

$12 USD in 6 days