asked on

SSIS 2008 - Truncate Data

Hi Experts,

This is my question:
Is there a way to truncate the data rather than error if it’s over 400 characters?
Is it SSIS that handles this?
Or is this done in SQL Server?

If so please help and show a way to do so?

Thanks

SOLUTION

rtay

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rtay

One warning that I forgot was that the data type must be DT_WSTR. So you can change the data type to that string format and then change it back to the original type before database insert if necessary.

Amour22015

ASKER

i myself am kind of new to SSIS, but what would SSIS have to do with Truncation problems with a table in SQL?
I mean would not the problem be maybe some kind of SP?

rtay

Maybe I don't understand your question. Are you bringing in data from a source file / database etc and trying to normalize it to bring it into a destination table? If you are, and one of the fields is over 400 characters and the destination only accepts 400 characters, you would use the derived column to fix the issue before the data is inserted.

if that is not what your looking for, please give me some more info and I will see if I can help.

ASKER CERTIFIED SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Amour22015

ASKER

These are the questions I need to go back with and ask, thanks.

Amour22015

ASKER

So this is my response to the question:

I was hoping you would be able to look at the SSIS and let us know if the developer set the import for that field to truncate rather than error if the data coming in from the file is over 400 characters.

So how would one do this?

Looks like there would be some kind of SP that could take care of this?

I don't think SSIS deals with this directly?

Right now I am having trouble opening the SSIS package I get this:
See Attachment
SnapShotOpen.docx

Vitor Montalvão

First of all you can insert the image directly in you post.
Second, the error is access denied meaning that you don't have access to open the SSIS package.

Amour22015

ASKER

Turns out I did not have permission for SSIS package so I will not be able to check.