CODEWITHSUNDEEP
ssis
SidC
SidC

Reputation: 3213

SSIS Package Fails on Status Code 4

I've created an SSIS package that executes inline SQL queries from our database and is supposed to output the contents to a text file. I originally had the text file comma delimited, but changed to pipe delimted after researching the error further. I also did a substring of the FirstName field and ensure that the SSIS placeholder fields matched in length. The error message is as follows:

[Customers Flat File [196]] Error: Data conversion failed. The data conversion for   
column "FirstName" returned status value 4 and status text "Text was truncated or one or more 
characters had no match in the target code page.".

The SQL statement I'm using in my OLE DB Source is as follows:

SELECT     
dbo.Customer.Email, SUBSTRING(dbo.Customer.FirstName, 1, 100) AS FirstName, 
dbo.Customer.LastName, dbo.Customer.Gender, 
dbo.Customer.DateOfBirth, dbo.Address.Zip, dbo.Customer.CustomerID, dbo.Customer.IsRegistered
FROM         
dbo.Customer INNER JOIN
dbo.Address ON dbo.Customer.CustomerID = dbo.Address.CustomerID

What other fixes should I put in place to ensure the package runs without error?

Upvotes: 1

Views: 3214

Answers (1)

rvphx
rvphx

Reputation: 2402

Have you tried to run this query in SSMS? If so, did you get a successful result? If you havent tried it yet, paste this query in a new SSMS window and wait for it to complete. If the Query completes, then we dont have a problem with the query. Something could be off inside the package.

But if the query does not finish up and fails, you know where to look.

EDIT

On second thoughts, is your Customer source a flat file or something? It looks like there is a value in the Customer table/file which does not match with the output metadata of the source. Check your source again.

Upvotes: 1

Related Questions