dbTalk Databases Forums  

SSIS XML Data source nulls when Deployed

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS XML Data source nulls when Deployed in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mkipiniak@hotmail.com
 
Posts: n/a

Default SSIS XML Data source nulls when Deployed - 08-11-2006 , 03:17 PM






HELP!!! I am new to SSIS (but a DTS veteran) and this problem is
having me pull my hair out.

I am importing an XML document into 2 tables (tblOrder and tblItem) to
reflect the 2 levels (Order and Item) in the document. I have 2
seperate data flow tasks to do this. In code, each of these works.
When I deploy my package, the Order entity imports into the table fine.
The Item entity populates my table entirely with nulls. Any ideas?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.