Home ForEach Loop Container does not pass variables to DataFlowTask
Reply: 0

ForEach Loop Container does not pass variables to DataFlowTask

user853
1#
user853 Published in August 15, 2018, 11:17 am

I have ForEach Loop Container (FEL Container) with DataFlowTask (DFT) in my SSIS. In DFT there is OLE DB SRC with SQL Comand coming from variable "DateToSelect" . This variable have two parameters - StartDate & EndDate, which I pass in my FELC Container. The goal of SSiS is to load table on SQL Server for certain periods

Problem is the next - SSIS runs without errors - but information do not load in table. I have put Breakpoints and Watches to see either my variables are changing - and they really do, but still nothing is loading.

Have somebody ideas what is wrong?

I have mentioned one more detail - package downloads data only for april, while period is from january to april (or from february to april) and if I change period from january to march - again no data is downloading..

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.302516 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO