Showing posts with label processes. Show all posts
Showing posts with label processes. Show all posts

Friday, March 23, 2012

How could XML help us in our ETL packages on daily-basis?

Hi all of you,

I'm just a newbie with XML. Now we're moving all our DTS to SSIS packages. Most of them are simply processes that takes a plain file and loading these data into Sql table or in inverse way. So that I wonder what role will play XML here.

I mean, are there big differences between store data as XML format and nvarchar?

That sort of stuff.

Thanks in advance for any input,


http://msdn2.microsoft.com/en-us/library/ms187508.aspx

HTH