• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 460
  • Last Modified:

SSIS Package

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?


Thanks,
MTD
0
MoreThanDoubled
Asked:
MoreThanDoubled
  • 2
1 Solution
 
DcpKingCommented:
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.

hth

Mike
0
 
MoreThanDoubledAuthor Commented:
Thanks,

Your information was very usefull.
The following link also guided me in the right direction.
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/



Thanks
0
 
DcpKingCommented:
So you got it to work? Good! Well done!

Mike
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now