Terminé

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

Compétences : Business Intelligence, Serveur SQL Microsoft, SQL, SSIS (SQL Server Integration Services)

En voir plus : 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

Concernant l'employeur :
( 23 commentaires ) phoenic, Canada

Nº du projet : #18141076

Décerné à:

CodingCubicle

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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(0 Commentaires)
1.1

2 freelances font une offre moyenne de 43 $ pour ce travail

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(77 Commentaires)
6.3