Concluído

ssis package to sort file which has header record, actual records, trailer record

hello

i need help in writing SSIS package without sorting header record and trailer record.

only actual data should be sorted on 1st column which has length 1 character.

sample Input File([login to view URL])

H1020XXXXXXXXXX

509090909092343

132423423432434

343242342342343

T12295834958

sample output file([login to view URL]) similar to below:

H1020XXXXXXXXXX

132423423432434

343242342342343

509090909092343

T12295834958

"header record starts with "H"

Trailer records starts wtih "T"

resultant file should have "Header record as first record, trailer record as last record".

only actual data should be sorted ( please see sample output)

Thanks

Habilidades: Business Intelligence, Microsoft SQL Server , SQL, SSIS (SQL Server Integration Services)

Veja mais: ftp task ssis package, ssis package extract sql data text file, ssis package creator, project using ftp task ssis package, ftp ssis package example, ssis package ftp file, ssis package projects, sql ssis package ftp, ftp ssis package, ftp task import files ssis package, ftp receive single file ssis package, ssis package sample ftp, data extract ssis package data txt file, ssis package data ftp, ssis package delivery, ssis package extract file daily basis, ssis package sql job ftp error

Acerca do Empregador:
( 21 comentários ) phoenic, Canada

ID do Projeto: #18141076

Concedido a:

CodingCubicle

Hello, We are expert in Microsoft technologies specially in SQL server and SSIS. We can do this project for you asap

$35 USD em 1 dia
(0 Comentários)
0.0

3 freelancers estão ofertando em média $38 para esse trabalho

mpalgeo

Hi I have been working with MSSQL for over 18 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 de Mais

$50 USD in 2 dias
(74 Comentários)
6.3
technospike9

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Mais

$28 USD in 7 dias
(0 Comentários)
0.0