home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,033 of 19,505   
   tshad to All   
   SSIS mappings not showing correctly   
   16 Dec 10 16:33:15   
   
   From: tfs@dslextreme.com   
      
   I was looking at the SSIS tutorial using the samples provided by MS and   
   found something interesting.   
      
   For 2008, I went through the tutorial and it works fine.   
      
   But what I did see was that the mappings do not show correctly even though   
   it creates the new table correctly.   
      
   I went in and change some types and some sizes.   
      
   But when I went to the Data Conversion task in the Data Flow section and   
   double clicked on it, I found that the it only showed the columns in the   
   details pane that actually had the data types significantly change.  It   
   didn't show changes from nvarchar to nchar and didn't show length changes.   
   When you selected one where you did this it showed the original size.  For   
   example, I had changed the size for FirstName from 255 to 50 and it still   
   showed 255.  But if I looked at the table it created it did the mapping   
   correctly.   
      
   So the Data Conversion Transformation Editor was not correct.   
      
   Was curious if that was the case.   
      
   Thanks,   
      
   Tom   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca