That looks good but the SP uses a view to incert the data into tblclients:

INSERT INTO dbo.tblClients

(Client_Short_Name,

Client_Long_Name,

CountryCode,

ClientID)

SELECT dbo.vwImportAllNewClientIDs.Client,

dbo.vwImportAllNewClientIDs.Client, dbo.vwImportAllNewClientIDs.CountryCode, dbo.vwImportAllNewClientIDs.ClientID

FROM dbo.vwImportAllNewClientIDs

Where fore can I replace the above code...

Thanks,

I have changed all the vaules in the tblclient table to have the correct values, as you pointed out.

Now im having the following error:

Msg 2627, Level 14, State 1, Procedure...

That was extremely helpful…. THANK YOU VERY MUCH!!!! Chris Morris

Made me a happy man, I know thats sad but this has been hurting my head for the last 2 days!!

So...

Ok cant seem to get around this,

the error is:

Msg 8152, Level 16, State 4, Procedure procImportAllFiles, Line 33

String or binary data would be truncated.

The statement has been terminated.

This part...

Thanks VERY good idea!

Ok so the following line is bring the error:

INSERT INTO dbo.tblClients(Client_Short_Name,Client_Long_Name,CountryCode,ClientID) SELECT

dbo.vwImportAllNewClientIDs.Client,

dbo.vwImportAllNewClientIDs.Client,

dbo.vwImportAllNewClientIDs.CountryCode,

dbo.vwImportAllNewClientIDs.ClientID

FROM dbo.vwImportAllNewClientIDs

The View is a combination of 2 tables one of...

Sorry about the formatting.

Step One

I have a SSIS package which picks up and loads data from a flatfile (CSV) into 3 tables.

Step two

The SP then takes information from temp tables...

right sorry, your right I needed to remove that anyway.

That has now been removed but, now I have the following error:

Msg 8152, Level 16, State 4, Procedure procImportAllFiles, Line 33

String...

USE [book]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER Procedure [dbo].[procImportAllFiles]

AS

SET NOCOUNT ON

DECLARE @Today DATETIME

DECLARE @ImportDate DATETIME

SET @ImportDate = Convert(SMALLDATETIME,(SELECT convert(char(8),date) FROM CheckDate),3)

SET @Today =Convert(SMALLDATETIME, (SELECT GETDATE()),102)

--We only update and append if...

I cannot edit the CSV file.

How can I use Derived Column exspress to change the column value from: 24 Nov 2008

to: 24-NOV-08

Need help with the Expression.

thanks

(slowly going mad)

Withing SQL DB the column is defined as VARCHAR(16),Null

Within SSIS the column is defined as:

OutputColumnWidth - 16

DataType - String[DT_STR]

TextQualified - True

SteveB - Thanks for the clear reply!!

Looks like I have fixed the date issue by using DataType 'Unicode string [DT_WSTR]'

:crazy: ...Now I have an issue with a column which holds...

THANKS ALL for the info!

Is there a way of creating a SQL SP to do the data conversion?

(Please see the attached pic).

As the import is occuring in the DataFlow do...

Ok to out line the issue:

Importing a flat file (.CSV) via SSIS into SQL2005 DB.

The Flat file row looks like:

"MANAGERS LTD","B","19 NOV 2008","1.249547"

The error is with the date column

Within...

Thanks,

easier said than done... im a newbi to SSIS...

Any tips?

Thanks again, No unfortunatily its not a one off.

This file gets replaced everday and will be in the same format.

I will have a look that that thread, thanks.

What Data type...