Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

SSIS - Truncation Warnings Expand / Collapse
Author
Message
Posted Friday, October 5, 2012 12:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 12:42 PM
Points: 9, Visits: 70
That did not work for me.
So what I finally did for a csv source to Table. I added a data convesion task and the one coulum which was a headache, I created alises for that and then set that coulmn's the data type as the destination table.
so it worked and all got copied but I don't like it.

I am going to try Excel now and I am afraid it not going to work
Post #1369265
Posted Tuesday, May 7, 2013 9:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 7, 2013 8:59 AM
Points: 1, Visits: 24
right click on component and click show advanced editor. you can change the meta data column type
Post #1450208
Posted Monday, August 18, 2014 5:24 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, August 25, 2014 10:25 PM
Points: 698, Visits: 158
Its hard to debug and see where exactly the issue is .But one quick solution is

step 1 : delete the destination component
step 2 : Recreate the same component
Step 3 : Create the object instead of using existing table/file(by click on new button) .
Step 4 : Check the step 3 generated script with existing one.
Step 5 : Modify the previous one or Rename the new table with actual .

@mit :)
Post #1604371
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse