<div>
Thanks,<br />
<br />
Your information was very usefull.<br />
The following link also guided me in the right direction.<br />
<a href="http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/" rel="ugc">http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/</a><br />
<br />
<br />
<br />
Thanks
</div>


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/ [http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/]



Thanks

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

Mike

<div>
<div class="content wysiwyg-content">
Hi All, <br />
<br />
I am not too savy with SSIS packages. &nbsp;I just know the basics.<br />
<br />
What i need is to have a package execute a query that will determine if i need to <br />
<br />
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)<br />
<br />
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.<br />
<br />
<br />
i already have a database connection set up<br />
i am using MS VS 2008 / VB Script<br />
<br />
can some one help with this?<br />
<br />
<br />
Thanks,<br />
MTD
</div>
</div>


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

SSIS Package

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.

Web Languages and Standards

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.