Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 ssis 2005

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2007-07-05 : 08:24:25
Is it possible is SSIS to get the contents of an xml file and pass it on to a stored procedure?
Thanks

dineshasanka
Yak Posting Veteran

72 Posts

Posted - 2007-07-08 : 09:32:37
you can use SP to read XML file.
Then include this in a SSIS Data Source task. Then pass it to Another sp as parameters using SQL Comand object
Go to Top of Page
   

- Advertisement -