SSIS Package

Posted on 2012-08-29
Last Modified: 2013-11-18
Hi All,

I am not too savy with SSIS packages.  I just know the basics.

What i need is to have a package execute a query that will determine if i need to

1. get/capture the file name located in a table. i then will need to delete that data from the table (could be multiple filenames that will need to be captured)

2. and find that filename with a .xml extention in a directory and move it to another directory location renaming the extention of that filename.

i already have a database connection set up
i am using MS VS 2008 / VB Script

can some one help with this?

Question by:MoreThanDoubled
    LVL 16

    Accepted Solution

    You can use an ExecuteSQL block to fill an SSIS variable of type Object with a list of the filenames that are in the table, and then another to delete them all. In this case the Object acts like a Collection in C# or VB.Net.

    After that, use a ForEach block: the thing that gets iterated over is the Object variable that you just filled up from the SQL query. Within the block, your code is probably just the copy.



    Author Comment


    Your information was very usefull.
    The following link also guided me in the right direction.

    LVL 16

    Expert Comment

    So you got it to work? Good! Well done!


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Styling your websites can become very complex. Here I'll show how SASS can help you better organize, maintain and reuse your CSS code.
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…
    The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now