Hello,
I have a SSIS package that use stored procedures to transfers the data from sql to a txt file.
I run this package on the Test Server and don´t work fine if I don´t include sentences like:
IF 1 = 0
BEGIN
SELECT
CAST(NULL AS NVARCHAR(1224))AS [clEnt]
,CAST(NULL AS VARCHAR(15))AS [clTipoDoc]
,CAST(NULL AS VARCHAR(20))AS [clNroDoc]
,CAST(NULL AS VARCHAR(100))AS [clNombre]
,CAST(NULL AS VARCHAR(5))AS [clSexo]
,CAST(NULL AS VARCHAR(5))AS [clEstCivil]
,CAST(NULL AS VARCHAR(5))AS [clNacion]
,CAST(NULL AS VARCHAR(100))AS [clCalle]
,CAST(NULL AS VARCHAR(6))AS [clNumero]
,CAST(NULL AS VARCHAR(10))AS [clPiso]
,CAST(NULL AS VARCHAR(5))AS [clDepto]
END
At the begin of the stored procedure. I need a unique large line in the text file, the others line only are mentionen but if I miss anyone it gets the error as below:
"The external metadata collumn collection is out of synchronization with the data source columns. The column "clEnt" needs to be update in the external metadata column collection"
Does it mean that I have to include these kind of instructions in the stored procedures?
any solution on this?
Thanks,
Patricia