January 29, 2008 at 8:25 am
I'm ready to jump and am hoping someone can talk me down. I have a package that has an excel connection, all of the columns in the excel document are text, when i setup a transformation from excel into a data conversion task and than into sql 2005, the metadata on some of the columns is showing a DT_DATE, i have no clue where its pulling that from, or what its looking @ to determine thats what it should be, but its preventing data from being imported into SQL from the sheet:w00t:.
January 29, 2008 at 9:06 am
A little more information, we just cant seem to get a column that was once a date column in excel to show up in my import. The column right now is text in excel, a string in the import, and its showing null for all columns that were once dates
January 29, 2008 at 10:27 am
Hi, if you use the ssis import-export wizzard, there is a sql-task first which creates the destination table. There you can define the layout of your sql-columns
the statement looks somehow like this:
CREATE TABLE [MyTable].[dbo].[tblFirmen] (
[id-DB] decimal(18,0),
[COMPANY0] nvarchar(100),
[JuridicalForm] nvarchar(50),
[STREET0] nvarchar(200),
[ZIP0] nvarchar(15),
....
)
GO
there you should see that some columns are defined as date - you can change the definition to i. e. nvarchar(50).
Regards,
Susanne
January 29, 2008 at 11:35 am
Thanks for the reply, im not even letting it get into the table yet, im just looking @ a preview of the data from the connection, and its showing nulls where i have numbers
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply