Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS file import Expand / Collapse
Author
Message
Posted Tuesday, September 18, 2012 6:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 17, 2014 11:09 PM
Points: 176, Visits: 481
Hi,

I would like to build a package that imports a file from a file server on a daily basis. the file is a .txt file and is saved as "Filename_20120102.txt", when importing this file I would like my package to ignore the date and just pickup the file using the file name.

Please assist.
Post #1360755
Posted Tuesday, September 18, 2012 6:55 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:07 AM
Points: 1,231, Visits: 9,668
I'd just use a For Each File Loop with Filename*.txt as its filter.

There's a tutorial here - it was written for 2005, but the process is the same for 2008

Post #1360757
Posted Tuesday, September 18, 2012 7:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 17, 2014 11:09 PM
Points: 176, Visits: 481
Thanks Howard, i'm on it will let you know how it goes
Post #1360768
Posted Tuesday, September 18, 2012 7:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 17, 2014 11:09 PM
Points: 176, Visits: 481
Hi Howard,

I tried it but my enumerator configuration is empty. could it be because I don't hav a full version of visual studio installed?

Post #1360794
Posted Tuesday, September 18, 2012 7:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:07 AM
Points: 1,231, Visits: 9,668
I think it's a UI bug. You have to drop down the Enumerator Selection and re-select "Foreach File Enumerator" and the options will appear.
Post #1360800
Posted Wednesday, September 19, 2012 12:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 17, 2014 11:09 PM
Points: 176, Visits: 481
Hi Howard,

Thanks, I got it right now and I managed to import the files.
Post #1361155
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse