SSIS not working on mixed columns case

Todd C

2009-06-11 16:24:01 UTC

The Case Sesetivity server setting may be the issue, but I think that is
geared more toward data comparison than object names.

Try using a SELECT Statement instead of Table/View in the source:

SELECT
ID AS ID,
Name AS NAME,
TYPE AS TYPE,
...
FROM dbo.POOL

Hope this helps.
=====
Todd C

Post by Test Test
I have simple SSIS pkg (SQL 2005) that takes data (source table to
target table) from source db to reporting database (target). On SQL job,
I am executing this pkg for 2 dbs (by passing 1 varaible and 2 OLE DB
connections - 1 source OLE DB, 1 desintation) - one step /db. The
dynamic exeuction is working Ok. Howerver, it is failing for Source2 db
- I think it is bc of mixed case isuse on columns.
Notice that in the Pool table in source DB2, the 2 columns are in small
case and 3 in caps. Upon executing the pkg on Source2 db, it is giving
Description: The external metadata column collection is out of
synchronization with the data source columns. The column "ADDRESS" needs
to be added to the external metadata column collection.
The column "TYPE" needs to be added to the external metadata column
collection.
The column "FLAG" needs to be added to the external metadata column
collection.
The "external metadata column "flag" (582)" needs to be removed from the
external metadata column collection.
The "external metadata column "type" (579)" needs to be removed from the
external metadata column collection.
The "external metadata column "address" (576)" needs to be removed from
the external metadata column collection.
Source DB 1: ---- all columns in SMALL case
CREATE TABLE [dbo].[Pool](
[Id] [int] NULL,
[name] [varchar](50) NULL,
[address] [varchar](100) NULL,
[type] [varchar](20) NULL,
[flag] [varchar](10) NULL
)
Source DB 2: -- columns in both SMALL and CAPS
SourceTable: Pool
(
CREATE TABLE [dbo].[Pool](
[Id] [int] NULL,
[name] [varchar](50) NULL,
[ADDRESS] [varchar](100) NULL,
[TYPE] [varchar](20) NULL,
[FLAG] [varchar](10) NULL
)
-- all columns in CAPS
CREATE TABLE [dbo].[Pool](
[ID] [int] NULL,
[NAME] [varchar](50) NULL,
[ADDRESS] [varchar](100) NULL,
[TYPE] [varchar](20) NULL,
[FLAG] [varchar](10) NULL
)
Plese assist in resolving this issue. what are the options?
Thank you!
*** Sent via Developersdex http://www.developersdex.com ***