-1
votes
1answer
93 views

SQL import data when both source and destination has data and identity column

I am using Import and export data option to import data from one database to another database. Both database have similar structure of tables. All the tables have primary key which is identity ...
0
votes
2answers
64 views

CSV data export to SQL Database with double quote problems

I am trying to import data from falt files (.CSV) into SQL table. I am able to import them no problem but the data is coming with double quotes. What is the best way of resolving this problem? ...
3
votes
1answer
243 views

VLDB with large quantity of data file imports

I am a little out of my league with this scenario and hope this community can help get me on the right direction. I have recently been tasked with re-designing and implementing a database application ...
3
votes
3answers
978 views

Fixed length text file insert into SQL table

I am not a DBA on this one and I will not have access to BCP or anything like that. So I'm wondering if there is still a way to do it in SQL keeping it very basic. I have 100's of text files that ...
0
votes
2answers
417 views

Import batches of rows from Excel in parallel

We receive an Excel file weekly currently containing about 250k rows. The file grows by about 300 rows each week. In SSIS I've hooked up an Excel source to an OLE DB destination to import the file ...
1
vote
1answer
137 views

ssis delete database on error

I'm writing an ssis package that imports a number of access databases nightly. Each database has the potential to have a slightly different schema. Since I'm creating the tables than doing a direct ...