Automatically create rowid from import excel to SQL Server

More
4 years 3 weeks ago #22049 by nveger
I have exactly the same drivers. I installed MS SQL Server Management Studio yesterday on my laptop and got these drivers.

I am not sure if these drivers are then also automatically used by the tool, but for sure I have the latest drives.

Hope to hear back from you on this...

Please Log in or Create an account to join the conversation.

More
4 years 3 weeks ago #22050 by nveger
here a screenshot of my drivers on ODBC

Attachments:

Please Log in or Create an account to join the conversation.

More
4 years 3 weeks ago #22051 by admin
Thank you for providing additional information.

I assume you have our software and SQL server installed on the same computer?

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
4 years 3 weeks ago #22052 by Peter.Jonson
Hi

I am trying to reproduce the issue you are having in our office.

Can you provide us with the following information, please
Source file
Mapping
Table creation script
are you using the 64-bit version of our software or 32 bit?

Thank you,

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
4 years 3 weeks ago #22053 by nveger
Hi Mike,

sorry for the delayed reply. Yes they are both on the same server.

Please Log in or Create an account to join the conversation.

More
4 years 3 weeks ago #22054 by nveger
Hi Mike,

how can I give you the mapping? Is this something I can extract from the tool?

I am using the 64-bit version of your software.

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save