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: Thursday, June 5, 2014 1:02 PM
Points: 9, Visits: 69
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
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse