Lengkap

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

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

Lihat lagi: 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

Tentang Majikan:
( 21 ulasan ) phoenic, Canada

ID Projek: #18141076

Dianugerahkan kepada:

CodingCubicle

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

$35 USD dalam sehari
(0 Ulasan)
0.0

3 pekerja bebas membida secara purata $38 untuk pekerjaan ini

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 Lagi

$50 USD dalam 2 hari
(74 Ulasan)
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 Lagi

$28 USD dalam 7 hari
(0 Ulasan)
0.0