Any MSSSQL 2008 Users?

Discussion in 'OT Technology' started by CyberBullets, Mar 14, 2009.

  1. CyberBullets

    CyberBullets I reach to the sky, and call out your name. If I c

    Joined:
    Nov 13, 2001
    Messages:
    11,865
    Likes Received:
    0
    Location:
    BC, Canada/Stockholm, Sweden
    Anyone have any luck with SSIS using dynamic sources (csv files in a foreach loop) to dynamic OLE DB destinations? I've been doing some research and it doesn't seem to play well with variables on both ends.
     
  2. CyberBullets

    CyberBullets I reach to the sky, and call out your name. If I c

    Joined:
    Nov 13, 2001
    Messages:
    11,865
    Likes Received:
    0
    Location:
    BC, Canada/Stockholm, Sweden
    No, it's not that.

    The problem is every morning I get ~20 csv files sent to my ftp server. We pull them off and want to import them. Right now it's fairly simple as each of those goes to their own table. The structure is the same for the csv files and tables. What I want to do is have it so the OLE Destination can be generated at runtime, unfortunately setting the connection in the expression of the OLE Destination doesn't work. I may just end up writing some C# to take care of that.
     

Share This Page