Flat file to Sybase using SSIS

Hi there. Have a very weird problem.I am loading a flat file into Sybase db using SSIS package(tried both 2005 and 2008). Values in one of columns in flat file are 6-8 digits numbers. This column is loaded into Sybase table column with format INTEGER NOT NULL. Here comes the problem: when the destination column is NON NULLABLE somehow only first 4 digits of the values are exported. E.g. the value in the flat file is '65002343' but only 6500 appears in the destination column Or value '241209' "converted" to 2412. If I change the destination column format to be INTEGER NULLABLE or VARCHAR(25) NON NULL, then there is no problem, values are transferred without any issues. Any ideas why would this be happening and how to fix it without changing the format of the destination column?
more ▼

asked Nov 10, 2011 at 09:49 PM in Default

Oleg Yuriev gravatar image

Oleg Yuriev
21 2 2 3

(comments are locked)
10|1200 characters needed characters left

0 answers: sort oldest
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Nov 10, 2011 at 09:49 PM

Seen: 811 times

Last Updated: Nov 14, 2011 at 02:04 PM