This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 3%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
I have a .csv that has 4 columns that I need to insert data from two of those columns into two different tables. Two of those columns I need to join to two different tables to do insert statements into the two tables. Anyone know how to do this?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Please clarify what you are using:
I'd like to use SSIS, but I am not a DBA and can't even figure out how to use it after it's installed and can't seem to even find it. So T-SQL will have to do.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Is this a one-time import or scheduled?
If this is one time, you can just use the import/export wizard to import it into a table. Then write TSQL to do the inserts into the target table.
It will be scheduled to run daily.
I've also figured out how to get to SSIS but it appears I will need to install a package for one of the folder paths under Data Collector. Does anyone know which folder I should use for this and which Package I should install?
Does anyone know which folder I should use for this and which Package I should install?
It is not clear what you are asking.
A screen shot would be handy.
The simplest way to do what you describe it to import the CSV into a "staging" table, and then write TSQL to do what you need to do.
Yes, as Tom says, for a solution without SSIS (which I don't know myself), you need to import the file into a table, and then work from the table.
If the file is located so that you can access it from SQL Server, you can use the BULK INSERT command.
If it is not, you may be able to import it with the command-line utility BCP.
We also need which version of SQL Server you are using. What's the output of "SELECT @@version"?
Its 2014 Standard
OK, so this means no matter you use BULK INSERT or BCP, you cannot handle a file like this:
1,My text goes here,19,23
2,"This text, has a comma in it",99,22
That is, a file where text is quoted sometimes, and sometimes not. If fields are quoted consistently, or not all there are no problems. But you only said CSV file, and that can be both this and that.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Hi @MR BILL ,
Best Regards,
Mona
----------
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?