Mensaje
De
05/10/2006 23:22:58
 
 
a
05/10/2006 11:10:49
Evans Carl
System Answers Consulting, Inc
Big Lake, Minnesota, United States
General information
Foro:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
ID de la conversación:
01158769
ID del mensaje:
01159931
Views:
29
>Sorry for the later replies, I'm working at a client site.
>
>SSIS does have a for loop container. You can set a counter to stop at 80 iterations.
>
>Also, the verify your row imports, you can right click on the green flow path and then select Data Viewer / Add. This will show you the exact data that is passing through the flow. It's a pretty cool for debugging.

Thanks, while I do undertand the concept of the For Loop Container, from the documentation I have seen, the expressions we can use are related to SQL Server. I don't know if such expression exists that will allow me to read the number of files in a directory, loop through them and apply a migration logic.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Responder
Mapa
Ver