pass xml file content as a varaiable

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)

pass xml file content as a varaiable

Author

Topic

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-10-08 : 02:38:53

I have developed a ssis package which loops through a folder and retrieves the name of the .xml files.
The name of the .xml file gets passed to a stored procedure using an Execute SQL Task as a variable.
Question:
How do I pass the content of the xml file to the stored procedure in the ssis package?
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-08 : 03:27:38

content of xml file? you mean the xml itself? then use data flow task to get xml onto staging table and acces it from table in storedprocedure

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-10-08 : 03:54:53

Yes, the xml inside the .xml file.
Do you mean to use xml task in the Data Flow and pass the xml content into a table and then use SP to get the data iin that table?
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-08 : 04:05:12

quote:
Originally posted by arkiboys

Yes, the xml inside the .xml file.
Do you mean to use xml task in the Data Flow and pass the xml content into a table and then use SP to get the data iin that table?
Thanks

yup. thats one of the way of doing it

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-10-08 : 04:22:59

Is it possible to pass the xml content from within ssis package into a stored procedure?
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-08 : 06:21:22