Flat File Source, please Help !!

Hot Topic

Moving the ReportServer database
Fuzzy Group Updates?
VS.NET 2005 and CLR stored procedure permission sets.
Adding SDF data into a Listview - C#
TOP URGENT PLZ: SQL backup files
string to int????
SQL 7 [DBNETLIB] 2147467259(80004005) [Connection write(send()),] General Network Error
SQL Server 2005 System Table (View?) Map
Droppinga a default value
ForEach Config validation errors

SQL Server

SSIS doesn`t start after applying SQL Server 2005 SP1 error Message 7000 Service Control Manager
SQLEXPRESS CREATE DATABASE
2000 Client Connectivity .msi?
2005 mgmt studio -> 2000 clustered instance
Cannot shut down VS after using report designer
MS Reporting services
PeriodsToDate Behaviour in AS2005
Watermark Generation is Invalid Error
Wing Dings changed when exported to PDF
SSAS2005 currency conversion for calculated measures based on measure error

Flat File Source, please Help !!

Hi all

I have some problems with the "Flat File Source" ...
I am trying to load a textfile, but IS allways cuts the rows ...
When I look at the preview while designing, the row is complete,
so I am wondering what IS is doing ...

Thanks for any comments

Best regards
Frank Uray

Here is what I am trying to load (one row from the file):
WPBX1 1.2 19330065002695435000 001200526000 000020002002-11-13-11.17.55.2220262006-03-03-05.50.44.322629002000010001AG2006-03-03-05.50.44.322629WIS030EPF033200602173410567000101 271275 2006030220060303200603032006030320060303 200603032006030320060303 200603032006030320060303200603031 0.000 200.000A UWCE 1 24617 10844890000000000 0.000000 0.000 0.000 0 149.500 149.500 149.500 00100010 0.000000000000000E+00 0.000000000000000E+00 0.000000000000000E+00 0.000000000000000E+00 1.000000000000000E+00 1.000000000000000E+00 0.000000000000000E+00 0.000000000000000E+0000 0000000001CV EE 00 1.150 200.000 0001-01-01-00.00.00.00000000120052600071200180K 712 71550 230.000 230.000 230.000 0.000 230.0000010 C 100.000000 2006-03-03-05.50.44.3226291567 230.000 230.000 230.000 0.000 230.0000010 C 100.000000 2006-03-03-05.50.44.3226291568 230.000 230.000 230.000 0.000 230.0000010 C 100.000000 2006-03-03-05.50.44.3226291585 230.000 230.000 230.000 0.000 230.0000010 C 100.000000 2006-03-03-05.50.44.3226291590 -80.500 -80.500 -80.500 0.000 -80.5000010 C 35.000000 2006-03-03-05.50.44.3226291640 -80.500 -80.500 -80.500 0.000 -80.5000010 C 35.000000 2006-03-03-05.50.44.3226291830 149.499 149.499 149.499 0.000 149.4990010 C 65.000000 2006-03-03-05.50.44.322629

On SQL Server I get only this:
WPBX1 1.2 19330065002695435000 001200526000 000020002002-11-13-11.17.55.2220262006-03-03-05.50.44.322629002000010001AG2006-03-03-05.50.44.322629WIS030EPF033200602173410567000101 271275 2006030220060303200603032006030320060303 200603032006030320060303 200603032006030320060303200603031 0.000 200.000A UWCE 1 24617 10844890000000000 0.000000 0.000 0.000 0 149.500 149.500 149.500 00100010 0.000000000000000E+00 0.000000000000000E+00 0.000000000000000E+00 0.000000000000000E+00 1.000000000000000E+00 1.000000000000000E+00 0.000000000000000E+00 0.000000000000000E+0000 0000000001CV



Answer this question

Flat File Source, please Help !!

  • Vanpelt

    Hi

    Thanks for your comment!

    I have checked this allready.

    It has something to do with these characters ( EE) ...

    Best regards
    Frank Uray

  • RBear3

    hi,

    have a look at section fifty in the ProjectREAL docs, which may pertain to this situation.

    http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql90/html/SQL05InSrREAL.asp

    drew



  • Sridhar Madhugiri MSFT

    I think, if lenght is correct then ( )this might be set as a delimiter..

    Chek in advanced properties

  • Sasikumar

    Open the File connection manager and look at the advanced settings. Look at the output column width. By default the system sets it to 50. Increase this and it should work. Make sure this width matches the width on your field in the table.

  • SAPUTELLO

    Hi

    The delimiter is set to "{CR}{LF}".
    The problem is this character ( ), the question is how
    can IS load such a row
    As I told before, the preview in connection manager is correct.

    Best regards
    Frank Uray

  • Dan Rowley

    I can't be of much help here except to say check the data types in your flat file conenction manager. What are they set to

    -Jamie



  • David Harrison_ch

    Hi Jamie

    The DataType is set to: "string [DT_STR]"
    I have also tried "text stream [DT_TEXT]"

    IS seems not to be very consistently because why
    is it correct on the Connection Managers Preview

    Best regards
    Frank Uray
  • Flat File Source, please Help !!
Answer this question