sql server - Exclude specific Sub Folders -


i got package runs through folder , it's sub folders client data. agreement has changed , client post data in different folder name every time. wondering if can foreach loop on main folder , exclude specific folders archive .

i don't have knowledge in writing scripts wondering if ssis can without script.

using execute script task

get list of - filtered - files using execute script task before entering loop , loop on using foreach loop container (ado enumerator)

  1. you have a ssis variable (ex: user::fileslist) type system.object (scope: package)
  2. add execute script task before each loop container , add user::fileslist readwrite variable

  3. in script write following code:

    imports system.linq imports system.io imports system.collections.generic  public sub main()     dim directory string = "c\temp"     dim strsubdirectory string = directory & "\new folder"     dim lstfiles new list(of string)     lstfiles.addrange(directory.getfiles(directory, "*.*", searchoption.topdirectoryonly).where(function(x) not x.contains(strsubdirectory)).tolist)      dts.variables.item("fileslist").value = lstfiles      dts.taskresult = scriptresults.success end sub

  4. in each loop container choose enumertaion type from variable enumerator , choose fileslist variable source

screenshots

enter image description here

enter image description here

enter image description here

using expression task

for more details can refer answer in following link (it similar case) wildcards in ssis collection {not include} name xlsx


Comments

Post a Comment

Popular posts from this blog

'hasOwnProperty' in javascript -

i use obj.hasownproperty judge whether object has property, when replaced obj[prop] !== undefined , not normal implementation, ask, why behind method can not use it? object.hasownproperty(prop); object[prop] !== undefined; obj[prop] !== undefined wrong 2 reasons: you can explicitly set property undefined , obj[prop] = undefined; . obj.hasownproperty(prop) return true in case. obj[prop] follow prototype chain, return property that's inherited. obj.hasownproperty(prop) returns true if property exists directly in object, returns false inherited properties.
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more