Post reply

DTS QRY URGENT

  • May 30, 2008 at 9:14 am

    #94197

    I have 3 folders in a FTP Location..(X1,X2,X3),

    I want to create a DTS package which will go to these folders daily and if a new files exists then I need to pick that file and process those details in another DTS Package once finished again should loop the same for another file if any in the same folder, then it shuld go to the next folder and do the same till all the files are processed in all folders.

    CAN SOME BODY PLEASE HELP ME ITS URGENT

    Thanks in advance

  • May 30, 2008 at 9:26 am

    #822412

    you can use the ForEach Loop container in BIDS

    to loop through your folders to find the latest files.

  • May 30, 2008 at 9:32 am

    #822416

    Please don't cross post. It just fragments replies and wastes people's time. Many of the regulars read all the forums.

    No replies to this thread please. Direct replies to:

    http://www.sqlservercentral.com/Forums/Topic509190-19-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply