Post reply

filename management

  • June 10, 2010 at 8:49 am

    #233632

    Hi everyone,

    My question is pretty simple. I have a directory with several .xls files in it.

    I want to retrieve the name of those files and put the name into a sql database for process purposes.

    I guess I can do that with SSIS using a for each loop container but I am a little stuck.

    Did someone already see that problem?

    Thanks

  • June 10, 2010 at 9:43 am

    #1178700

    Couple of things, first if this is really an SSIS question you might have better luck posting it in the SSIS forum. Secondly, yes SSIS is one way to do this, there are a variety of others, Powershell, Perl and javascript all come to mind as well as batch files with sqlcmd.exe.

    Perhaps you can elaborate on exactly what you're stuck on in creating an SSIS task? This might be a good starting point for you.

    http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • June 10, 2010 at 11:04 am

    #1178780

    it helps Thank you

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

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