Its complaining about invalid token or may not be well formed.

not sure about the old one but new one is 32 bit.

I get the following error :

An OlEDb error has occured . error code 0X80004005

An OLE DB record os available. Source Microsoft office access database engine" Description : Invalid argument.

The acquire...

No it did not.

I don't have any control over the source excel file. Is there any way I can convert it ?

I am using a sql command in place of a oledb destination to populate the table. The sql command executes a stored proc and the returns the value of ColA...

Got it

ALTER PROCEDURE usp_PreInsert

@File_ID INT

AS

BEGIN

IF (SELECT COUNT(Has_Errors) AS Errors_Entity FROM dbo.Staging_Entities

WHERE File_ID = @File_ID AND Has_Errors > 0

UNION

SELECT COUNT(Has_Errors) AS Errors_Contracts FROM dbo.Staging_Contracts

WHERE File_ID = @File_ID AND Has_Errors >...

I am trying to do something like this :

ALTER PROCEDURE usp_PreInsert

@File_ID INT

AS

BEGIN

IF (SELECT COUNT(Has_Errors) AS Errors_Entity FROM dbo.Staging_Entities

WHERE File_ID = @File_ID AND Has_Errors > 0

UNION

SELECT COUNT(Has_Errors) AS Errors_Contracts...

This worked. thanks.

I need to do something like this but not getting the correct syntax:

SELECT CSP.P_Degree_Name

(CASE WHEN CSP.P_Degree IS NULL THEN NULL

ELSE

( SELECT CSP.P_Degree_Name,DEGREE_ID FROM...

Thanks .

Yes, I am sure that I am using the right database .

Replace and Substring worked for me. Thanks

Can you give an example .

I was looking for something like this 713-777-9906