question

waqar avatar image
waqar asked

SSIS: FETCHING THE BLOB FILE WITH ITS FIRST NAME AND IGNORING the remaining part of file NAME IN SSIS AZURE SOURCE BLOB

am using ssis component "Azure Source Blob" there is a file in blob storage with name "Material123445.csv"

i want to fetch this file with its frist name "Material" and rest of the name "123445" should be ignore because these digits will be changing on daily basis. so these digits cant be hardcoded

how to handle this thing please check the image attached

ssis 2012
capture.png (20.3 KiB)
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.

1 Answer

·
DaveC avatar image
DaveC answered

@waqar You can notify people you would like to answer using the "ask an expert" button on the right, it's easier than copying everyone in via separate answers.


askanexpert.png (10.4 KiB)
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.

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.