Hi sir..... Is there any way to load the file name for a particular pattern whose name is changing by adding different date. For eg --- today's file is abc_11022023.txt and tomorrow it will come by abc_12022023.txt . I want the file to be picked whose name is changing
In the foreach loop, under Files you can give the value as abc_* This way it will import any file starting with abc_ and then after importing the file, move the file to archive folder, so that same file won't be imported again. And next day new file will be imported.
It depends project to project. I used this 2 weeks ago thus, thought to share this. There is a process which processes a file every day, thus we wanted to send an email if we did not get a file on a day thus implemented similar kind of thing.
Hi Aqil sir • excel column with all integer values in the first 8 rows and then its hold character or Alpha Numeric values in the rows below,the system by default identifies that column as an double - precision float (DT_R8) and sets all the cells with characters or Alpha numeric values as NULL.. So please give best example like ssis script task. And use task ( source to destination)
Hi sir..... Is there any way to load the file name for a particular pattern whose name is changing by adding different date. For eg --- today's file is abc_11022023.txt and tomorrow it will come by abc_12022023.txt . I want the file to be picked whose name is changing
In the foreach loop, under Files you can give the value as abc_*
This way it will import any file starting with abc_
and then after importing the file, move the file to archive folder, so that same file won't be imported again. And next day new file will be imported.
I feel like this would rarely be used. I've done a lot of ETL work and I've not used this.
It depends project to project. I used this 2 weeks ago thus, thought to share this. There is a process which processes a file every day, thus we wanted to send an email if we did not get a file on a day thus implemented similar kind of thing.
Super sir,i expected this video
Thank you Naveen Raja.
Hi Aqil sir • excel column with all integer values in the first 8 rows and then its hold character or Alpha Numeric values in the rows below,the system by default identifies that column as an double - precision float (DT_R8) and sets all the cells with characters or Alpha numeric values as NULL..
So please give best example like ssis script task. And use task ( source to destination)
OKay, will try to regenerate the same issue and will see how we can handle this.
@@learnssis 👍