May 14, 2008 at 9:28 am
Hi
We need clarifications for some other implementation through SSIS package.
1. The flat file which coming from the upstream server will be placed in the particular directory of the loadserver.This flat file will be moved to windows shared drive
folder(s:\) by SSIS FTP task,then the file name should be refered by flat file connection manager.
The flat file name will be like cmbwipsc00077.dat.The Sequence number in red color will keep on changing.In flat file connection manager,We just browse through
and select the file name.But it should be automated.That is,Once file is placed in shared drive folder,The unique file name should be refered automatically in order to
initiate the LOADING (loading into sql server 2005 staging tables)process.
2. The Flat file is validated whether it is having header and trailer information.The flat file name (eg. cmbwipsc00077.dat) will have sequence number ie 00077.This
sequence number will be checked against flat file header information which also gives the sequence number
Eg. 0HEADER AARDCMBC2007-02-25-04.22.1000077 (We should get the value from 36th position to 40th position(ie 00077)
and check with filename sequence numbber)
If both number matches,The Loading will be initiated.Same way checking happens with Trailer.If anything goes wrong,mail will be sent and Loading will not happen.
With Regards,
prabhu.m
May 14, 2008 at 11:19 am
You've described your scenario...what is your question?
Ben Sullins
bensullins.com
Beer is my primary key...
May 15, 2008 at 9:31 am
Hi,
We need clarifications in SSIS implementation for the below mentioned queries
Requirement : 1
The flat file which is coming from the upstream server will be placed in the particular directory of the loadserver linux Box.
Then,This flat file will be moved to windows shared drive folder(s:\) by SSIS FTP task. Once the flat files comes to shared drive,It should be referred dynamically by flat file connection manager one by one for the loading process.
Problem Area :
The flat file name will be like cmbwipsc00077.dat.The Sequence number in red color will keep on changing.In flat file connection manager,We just browse through and select a file name.But it should be automated.That is,Once file is placed in shared drive folder,The unique file name should be refered automatically in order to initiate the LOADING (loading into sql server 2005 staging tables)process .
Questions:
1. Is there any way for the flat file connection manager to select filename dynamically one by one from the particular
folder?
2. Is there any other way to accomplish this requirement through SSIS?
Requirement : 2
1 .we need to validate the flat file whether it is having header and trailer information.
2.The flat file name (eg. cmbwipsc00077.dat) will have sequence number ie 00077.This sequence number(00077) will be checked against flat file header information which also has the sequence number.
eg.. flat file header content : 0HEADER AARDCMBC2007-02-25-04.22.1000077
(We should get the value from 36th position to 40th position(ie 00077) from the flat file header information and check with filename sequence numbber)
If both number matches(Header number and filename sequence number),The Loading will be initiated.Same way checking happens with Trailer.If anything goes wrong,mail will be sent and Loading will not happen.
Questions:
1. Is there any way to accomplish this validation through SSIS package tasks? If so , please provide us the details.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply