ftp ssis

[onressy]

From the ftp ssis package running every 10 minutes, grabbing one to 4 fours small xml files on a remote server, would it be possible to auto populate tables when the xml arrives, tables in the same db, by parsing child elements from the xml? can sql2005 perform all this in one stored procedure and can that procedure be called from the ssis package?

Hope that wasn't confusing, thanks

 

[manmaria]

Can't you do with a filewatcher task? Tutorial for this can be found in

http://www.sqlis.com/default.aspx?23

HTH

 

[mrdenny]

Yes. You can load the xml files into staging tables using the BULK INSERT command in T/SQL then using the OPENXML commands you can parse the data and update the tables.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[onressy]

manmaria, I'm using sftp, i don think file watch has the ability to check if xml file exists on remote secure or maybe i'm missunderstanding your thoughts...


mrdenny,
How would i call the T/SQl with the bulk insert, would i use the Data Flow Task?