Solved

VB.net SQL staging tables

Posted on 2014-10-20
3
134 Views
Last Modified: 2014-10-21
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?
0
Comment
Question by:murbro
3 Comments
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points
Comment Utility
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
 
LVL 16

Expert Comment

by:Kamal Khaleefa
Comment Utility
MAYBE YOU WILL FACE SOME PROBLEMS IF DATA TYPES ARE DIFFERENT

http://msdn.microsoft.com/en-us/library/ms137830.aspx
0
 

Author Closing Comment

by:murbro
Comment Utility
Thanks very much
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now