Column 4 is the correct column, I just changed it for this example.

Are you just doing a regular file dump, Flat File > Ole db Destination ?

1. Batch job picks...

Within 'SQL Server Management', right click on the job and select 'View History'. Drill into the first Error (Red Cross) and you should see another error appear. ...

Hi,

Thanks for the suggestion.

Im try to (in the following order):

1 - Access an FTP server

2 - Copy a file to a new directory on the FTP server

3 -...

Anyone got any suggestions.... Im stuck in which way to go!

Thanks

Thanks looks good.

Thanks found it else where:

Len(clientid) = 3

The email would be sent periodically every morning.

Nice idea, but the results have to be imbedded within the body of the email. (e.g. HTML Email)

i.e. not an attachment

Yes do not post multiple posts!

- Surface Area Config

- Select the DB instand on left

- Drill down and find Remote connection

I have seen the following example:

EXEC master.dbo.xp_smtp_sendmail

@server = 'SMTP.UK.CORP.Company.COM',

@from = 'sqladmin@company.co.uk',

@to = 'Paul.Smith@company.co.uk',...

😀 YES FINALLY!!!!! Thanks to you!

So:

1. The SSIS Package picks up and imports the correct columns from all 4 flat files

2. The database datatypes are all correclty amended to accept...

Chris,

Thanks again.

I recreated the FlatFileConnection within SSIS.

Looks like there was a mapping issue.

All columns importing correctly now.

Regards.

thats incorrect I dont need 10 columns,

I can state how many columns i want to use and map them to the relative DB columns.

I have justed select Ignor for the...

Yes, correct there is 10 columns but I am only using 8.

Eight are in connection manager and Eight are mapped.

Following are my settings in Connection Manager

General

Delimited

NONE

{CR}{LF}

0

Column

Row Delimiter {LF}

Column Delimiter Comma...

Answer to the above ttow questions:

This is exactually how it is in a notepad file.

0007,24843.00,AAL.L,ANGLO AMERICAN,B1XZS82,05-DEC-08,24843.00,1.0000,GBP,GB00B1XZS820

No delimiters i.e. ""

Just commas between each column

When the file is imported, if I do...

Attched is a screen shot of the FlatFile Connection Manager.

Shows a preview of the column which is incorrect.

Column 8