![]() There is one little strange behaviour here that could cause unexpected results: *.xls will also return files with the extension. They eventually solved it in SQL 2012.ī) Select the folder where your sourcefiles are and use wildcard characters to specify the files to include in the collection. You have to selected it although it is already selected by default, but that's a little bug in the user interface. Go to the Collection tab and:Ī) Select Foreach File Enumerator. It's optional.Īdd a Foreach Loop Container to the Control Flow and give it a suitable name. Note: I addad a value (the filepath of one of the sourcefiles) to show in the expression later on. Create a string variable with the name FilePath. We need a variable to store the filepath in. The file enumerator loops through a collection of files within a folder and makes it possible to execute for example a Data Flow Task foreach of the files without manualy changing the connection string. ![]() The others will follow in the coming time. This article explains the File Enumerator. And here are some of my custom enumerators.Foreach ADO.NET Schema Rowset Enumerator.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |