question

GayatriPanigrahi avatar image
GayatriPanigrahi asked

Dynamic file name in SSIS

Hi,

I have excel file whose frequency is weekly. I need your help is below question.

File Name : Stock - 9 July 2018 - OwnerPartners.xlsx

1) 9 July 2018 is dynamic part in file name eg : 9th July 2018 is monday when file arrive on next monday date would be 16 July 2018 i.e. file name would be "Stock - 16 July 2018 - OwnerPartners.xlsx"

2) This excel file is having 8sheets where Sheet1 is having header on 4th row and data start from 5th raw. Sheet2........Sheet8 do not have header and data start from 1st raw.

3) How do i load all 8sheets data keeping above condition in mind.

sqlssisssis2012ssis 2012
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.