Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQL_SSIS_Dev
Starting Member
10 Posts |
 Posted - 2014-09-26 : 10:43:55
|
| Currently I am using a SSIS package to read data from a .dat file and load it into SQL Server tables.I am placing the input .dat file on the desktop. In the connection manager -> Browse option, I am pointing this file to create connection.The file naming convention is like - aSNAP_Data_20140926_P-2014-09-26_07.02.36However, I need the SSIS package to automatically read the input file from a folder which is located in a remote server. This folder has lots of files where input files are added on a daily basis with the date value in the file name as mentioned above.I want to schedule the SSIS package to run daily and take the latest file in the folder based on the date.Please let me know how to do it. Any help would be highly appreciated.....Thanks in advance. |
|
|
sunder.bugatha
Yak Posting Veteran
66 Posts |
Posted - 2014-09-30 : 09:24:52
|
| How many such files are generated daily ?Hema Sunder |
 |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-09-30 : 10:33:35
|
| in the control flow, use a FOREACH container. There you can put the file prefix/suffix with wildcards like 'file*.ext' and assign a variable that will receive the file name for each file the loop finds. From there you can use variable in the data flow to read the file |
|
|
|
RobertColes
Starting Member
1 Post |
Posted - 2014-11-12 : 02:02:03
|
| From the control move, make use of a FOREACH container. There you can set your report prefix/suffix using wildcards like 'file*. ext' along with determine a variable that can obtain the report label per report your loop detects. Through right now there you should utilize variable from the info move to learn your report.RobertColes |
|
|
|
|
|
|
How can SSIS package automatically read input file