Basics of XML and SQL Server, Part 5: Generate/Transmit XML with SSIS

Question

Post reply

Basics of XML and SQL Server, Part 5: Generate/Transmit XML with SSIS

Stan Kulp-439977

SSChampion

Points: 10062
More actions
April 4, 2012 at 12:02 am

#259481

Comments posted to this topic are about the item Basics of XML and SQL Server, Part 5: Generate/Transmit XML with SSIS

Viewing 14 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

Harold Buckner SSCarpal Tunnel Points: 4175 More actions · Answer 1

Good topic and a great article. Can you add or post a copy of the xml output so I can see the final format.

Thanks

Stan Kulp-439977 SSChampion Points: 10062 More actions · Answer 2

It is the same XML file that was created in Part 4

http://www.sqlservercentral.com/articles/XML/87963/

Harold Buckner SSCarpal Tunnel Points: 4175 More actions · Answer 3

Harold Buckner

SSCarpal Tunnel

Points: 4175

April 4, 2012 at 7:06 am

#1468802

I see. Thanks.

heb1014 Hall of Fame Points: 3790 More actions · Answer 4

I wonder if Service Broker or a Data Driven Subscription would have been a better solution.

krishna.konda SSC Enthusiast Points: 114 More actions · Answer 5

Hi there

When will your next series come up? I think you mentioned that you will cover on transforming XML file into a table.

When you do this, can you make sure XML is not flat but has various levels within one file?

It would be helpful for the project I am working on now.

Thanks

jsduifieiu Grasshopper Points: 19 More actions · Answer 6

n2012 comes, in order to thank everyone, characteristic, novel style, varieties, low price and good quality, and the low sale price. Thank everyone

==== ( http://www.fullmalls.com ) =====

$33 True Religion jeans, Ed Hardy jeans,LV,Coogi jeans,Affliction jeans

$30 Air Jordan shoes,Shox shoes,Gucci,LV shoes

50%Discount winter fashion :Sandle,t-shirt,caps,jerseys,handbag and brand watches!!!

$15 Ed Hardy ,LV ,Gucci Bikini

$15 Polo, Ed Hardy, Gucci, LV, Lacoste T-shirts

$25 Coach,Gucci,LV,Prada,Juicy,Chanel handbag,

$10 Gucci,Ed Hardy sunglasses

$9 New Era caps.

give you the unexpected harvest

==== ( http://www.fullmalls.com ) =====

qfgewoisdf Valued Member Points: 57 More actions · Answer 7

n2012 comes, in order to thank everyone, characteristic, novel style, varieties, low price and good quality, and the low sale price. Thank everyone

==== ( http://www.fullmalls.com ) =====

$33 True Religion jeans, Ed Hardy jeans,LV,Coogi jeans,Affliction jeans

$30 Air Jordan shoes,Shox shoes,Gucci,LV shoes

50%Discount winter fashion :Sandle,t-shirt,caps,jerseys,handbag and brand watches!!!

$15 Ed Hardy ,LV ,Gucci Bikini

$15 Polo, Ed Hardy, Gucci, LV, Lacoste T-shirts

$25 Coach,Gucci,LV,Prada,Juicy,Chanel handbag,

$10 Gucci,Ed Hardy sunglasses

$9 New Era caps.

give you the unexpected harvest

==== ( http://www.fullmalls.com ) =====

qfgewoisdf Valued Member Points: 57 More actions · Answer 8

n2012 comes, in order to thank everyone, characteristic, novel style, varieties, low price and good quality, and the low sale price. Thank everyone

==== ( http://www.fullmalls.com ) =====

$33 True Religion jeans, Ed Hardy jeans,LV,Coogi jeans,Affliction jeans

$30 Air Jordan shoes,Shox shoes,Gucci,LV shoes

50%Discount winter fashion :Sandle,t-shirt,caps,jerseys,handbag and brand watches!!!

$15 Ed Hardy ,LV ,Gucci Bikini

$15 Polo, Ed Hardy, Gucci, LV, Lacoste T-shirts

$25 Coach,Gucci,LV,Prada,Juicy,Chanel handbag,

$10 Gucci,Ed Hardy sunglasses

$9 New Era caps.

give you the unexpected harvest

==== ( http://www.fullmalls.com ) =====

qfgewoisdf Valued Member Points: 57 More actions · Answer 9

n2012 comes, in order to thank everyone, characteristic, novel style, varieties, low price and good quality, and the low sale price. Thank everyone

==== ( http://www.fullmalls.com ) =====

$33 True Religion jeans, Ed Hardy jeans,LV,Coogi jeans,Affliction jeans

$30 Air Jordan shoes,Shox shoes,Gucci,LV shoes

50%Discount winter fashion :Sandle,t-shirt,caps,jerseys,handbag and brand watches!!!

$15 Ed Hardy ,LV ,Gucci Bikini

$15 Polo, Ed Hardy, Gucci, LV, Lacoste T-shirts

$25 Coach,Gucci,LV,Prada,Juicy,Chanel handbag,

$10 Gucci,Ed Hardy sunglasses

$9 New Era caps.

give you the unexpected harvest

==== ( http://www.fullmalls.com ) =====

dfgfgjghdsfsdf Newbie Points: 9 More actions · Answer 10

====== http://www.clothes8.org ======

Air jordan(1-24)shoes $30

Handbags(Coach l v f e n d i d&g) $35

Tshirts (Polo ,ed hardy,lacoste) $15

Jean(True Religion,ed hardy,coogi) $30

Sunglasses(Oakey,coach,gucci,A r m a i n i) $15

New era cap $12

Bikini (Ed hardy,polo) $20

Accept credit card and free shipping.

====== http://www.clothes8.org ======

Stan Kulp-439977 SSChampion Points: 10062 More actions · Answer 11

I think this will help you.

http://blogs.msdn.com/b/mattm/archive/2007/12/11/using-xml-source.aspx

I think this is better than the way I was going to do it.

Stan Kulp-439977 SSChampion Points: 10062 More actions · Answer 12

I think this will help you.

http://blogs.msdn.com/b/mattm/archive/2007/12/11/using-xml-source.aspx

I think this is better than the way I was going to do it.

(I posted this once but it didn't show up, so I am trying again.)

Stan Kulp-439977 SSChampion Points: 10062 More actions · Answer 13

Here is another

http://www.youtube.com/watch?v=xQZ3mhV7DL8

Basics of XML and SQL Server, Part 5: Generate/Transmit XML with SSIS

Cookies on SQLServerCentral