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