question

rouzbehpm avatar image
rouzbehpm asked

Issue in import flat file

I want to import flat file to my Database using SSIS. File name has both date and time of generation. for example, file name is: report_20180820_09_25_18.csv. I've defined the expression to change the date part automatically. for the time part, since report is generated on different time each day, i need to define a expression in which SSIS looks for a file that the name is like report_20180820_*.csv (* means anything) Is there an solution to this issue?

ssis error
10 |1200

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.