Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-24 : 08:45:45
|
| Dan writes "Hey there SQL Team! I have a .csv file containing some sales data. I'm trying to import this into an already existing table in my database (I'm testing first on my personal developer system - Enterprise Manager Version 8). I go through the DTS setup; when I get to the 'Select Source Tables and Views' section I click on the Transform button. Up pops the 'Column Mappings and Transformations' window. OK, the default tab is 'Column Mappings', I adjust my 'Types' and 'Precisions' appropriately. Now, here's the problem, there are three radio buttons: 1.) 'Create Destination Table' 2.) 'Delete Rows in Destination Table'AND 3.) 'Append Rows to Destination Table' I want this data put into an existing Table, problem is, the second two radio buttons are grayed out. So, the DTS keeps trying to create a new table (and for some reason if fails - but this isn't important, as I want to import/append my data to an existing table ... which it's not letting me to). Forgive me if this is elementary information which I should have picked up in the 'Super Beginners - Very Slow Introduction to MS-SQL Server for mentally challenged users --- 101' class, but I'm stumped (and a bit under the gun - therefore also a bit nervous, which makes me irritable) . . . and no one wants that. LOL. Thank you in advance for any and all who can offer some assistance yet today (Jan. 21 - 12:15 CST).Dan" |
|
|
|
|
|
DTS troubles when importing from .csv file