> Hi,
>
> I am unable to put a Precedence Constraint within a For Loop
> Container, can I do so in SSIS ?
>
> Actually what I am trying to acheive is that I am Iterating the
> ForLoop on some File List which will pull one FileName out of the List
> at a go n pass on the file name to the FTP Task so that it hits the
> FTP Loaction n pulls down the file on local machine. Now, I need to
> check whether the download succeded or Failed n what to update the log
> accordingly. To acheive this I am trying to put a precedence on FTP
> task with the ForLoop Cotainer but the SSIS Designer doesnt allows to
> do that.
>
> If this is not possible plz suggest some alternative to this n also
> point to any source code available if any.
>
> Thanks,
> Sachin R. Chavan.

> Hello Mitchell
>
> Well, my other tasks which are the Script Tasks are within the same
> For container itself but when I right click the FTP Task and select
> Precedence Constraint these two task doesnt appear in the connect to
> drop down of the Precedence Constraint settings window??
>
> What may be the possible problem?
>
> Thanks,
> Sachin.
> "Allan Mitchell" wrote:
>
>> Hello Sachin,
>>
>> Within the container you can "Precedence constrain" the other tasks
>> within to each other. What you cannot do is take a task within the
>> container and try to join to one outside of the container.
>>
>> --
>>
>> Allan Mitchell
>> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com
>> |
>> http://www.konesans.com
>>> Hi,
>>>
>>> I am unable to put a Precedence Constraint within a For Loop
>>> Container, can I do so in SSIS ?
>>>
>>> Actually what I am trying to acheive is that I am Iterating the
>>> ForLoop on some File List which will pull one FileName out of the
>>> List at a go n pass on the file name to the FTP Task so that it hits
>>> the FTP Loaction n pulls down the file on local machine. Now, I need
>>> to check whether the download succeded or Failed n what to update
>>> the log accordingly. To acheive this I am trying to put a precedence
>>> on FTP task with the ForLoop Cotainer but the SSIS Designer doesnt
>>> allows to do that.
>>>
>>> If this is not possible plz suggest some alternative to this n also
>>> point to any source code available if any.
>>>
>>> Thanks,
>>> Sachin R. Chavan.

"Charles Wang[MSFT]" wrote:

> Hi Sachin,
> I understand that you could not see the Script tasks when you click Add
> Precedence Constraint on the pop menu of your FTP Task. The three tasks are
> within the same For Loop Container.
> If I have misunderstood, please let me know.
>
> Per my test, you could not see the Script Tasks in Precedence Constraint
> selector if they are within the same container of the FTP task.
> You may try adding the Preceduence Constraint before you drag the tasks
> into the For Loop Container.
>
> Please feel free to let me know if you have any other questions or
> concerns. Have a good day!
>
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> =====================================================
> Get notification to my posts through email? Please refer to:
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
>
> If you are using Outlook Express, please make sure you clear the check box
> "Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
>
>
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ======================================================
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================
>
>
>
>