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.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 How can SSIS package automatically read input file

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.36

However, 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
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -