Friday, March 9, 2012

Importing data into a view

Hi all,
I am trying to import data from dbf files into a sql view using DTS. I
see that only buck copy allows me to import data into a view. I can't use
this because I need to choose which rows and columns I need to import when I
am importing them. What is the easiest way to import data into view?
Thanks in advcance...If you are very new to SQL Server then I recommend that you should import
data into a dummy table in SQL Server and put your filter clauses after you
have imported data into SQL Server. If you want to do lot of transformation
then you should use DTS instead. If you are a newbee then just import data
into SQL Server without filter clause and filter it once you have imported
data,
"Nikhil Patel" wrote:

> Hi all,
> I am trying to import data from dbf files into a sql view using DTS. I
> see that only buck copy allows me to import data into a view. I can't use
> this because I need to choose which rows and columns I need to import when
I
> am importing them. What is the easiest way to import data into view?
> Thanks in advcance...
>
>

No comments:

Post a Comment