Click here to Skip to main content
14,603,916 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hi,

I have some xml file like
<xml>
<file-location directory="c:\temp" foldername="core.txt"></file-location>
<file-location directory="c:\temp" foldername="menu.csv"></file-location>
<database username="xxx" password="ccccc"></database>
</xml>


I have xml file in this format like it contains file names and database login details also.My question is am extracting xml file using ssis to sql operation in the middle i am reading the text or csv files in that required location and read the data and stored into database. How can i read these text files and stored into database. this total was done in the middle of xml to sql operation in ssis. Can any one help me please,its very urgent for me
Posted
Updated 22-Jul-14 19:02pm
v2
Comments
PIEBALDconsult 23-Jul-14 1:04am
   
I'd use a Script Task. But why use SSIS at all?
naga pravallika 23-Jul-14 1:28am
   
The client requirement is using SSIS for inserting large amount of data in database

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100