Import from Access - Datatype conversions

Hot Topic

Error trying to create cube partition
Returning "ALL" records in a query
HelloWorld_CLR not sending messages anymore...........
INSERT statement conflicted with COLUMN FOREIGN KEY SAME TABLE constraint
How to create a row that calucates percentage in a Tabular report, RS 2005?
Passing MDX queries to ReportViewer reports
How to copy a DB, with T-SQL?
Semi-Blocking Script Transformation
Custom Semi-Transparent bar charts?
Can't Install SQL 2000 service pack 4

SQL Server

Export to Excel 2000
How to relate InstanceID of RunningPackage object to logging?
10 Slowest Performing Queries
export OLAP in SSAS 2005 to excel pivot table
How to delete rows in tables...
Unary Operator. Why Aggregate function don't respect unary operator?
What version: Enterprise manager or Management Studio Express
Procedure or Function 'insertProjectDetails' expects parameter '@ProjectTitle', which was not supplied.?
UDM and Data Mart
Secure Replication from Cluster to Workgroup

Import from Access - Datatype conversions

I have to do a lot of inporting from Access files.  Is there a place where I can change the default datatype conversion for Access Text from nvarchar to varchar

Thanks.

Kato




Answer this question

Import from Access - Datatype conversions

  • Wayne.C

    Outstanding. Exactly what I was looking for.

    Thank you.



  • Tim Rupe

    If you are using the import wizard then you can affect this with the mapping files at:

    %PROGRAMFILES%\Microsoft SQL Server\90\DTS\MappingFiles

    I'm guessing that the one you want is JetToSSIS.xml

    If you are building packages manually then you can change this in the source adapter.

    -Jamie



  • Import from Access - Datatype conversions
Answer this question