VB.net SQL staging tables

Hi

I plan on using a set of tables to upload multiple flat files to SQL.
The files are from SAP and I don't have a full list of the column data types.
Is it ok/advisable to use only text type columns in the staging tables and then convert these
later?
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
I suggest you to load the tables with the SQL Server Import Wizard. It can detect the data types for each column and saves you time and headaches.
0
 
Kamal KhaleefaInformation Security SpecialistCommented:
MAYBE YOU WILL FACE SOME PROBLEMS IF DATA TYPES ARE DIFFERENT

http://msdn.microsoft.com/en-us/library/ms137830.aspx
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
All Courses

From novice to tech pro — start learning today.