<div>
Thank you for your quick reply!<br />
<br />
This worked well after enabling 'Ad Hoc Queries' on the DB instance.
</div>


Thank you for your quick reply!

This worked well after enabling 'Ad Hoc Queries' on the DB instance.

<div>
<div class="content wysiwyg-content">
Experts,<br />
I have a need to import a csv file that has the first row as column names into a table in an SQL2008 database. This must be done through the use of TSQL. This table will contain over 100 columns. The destination table column datatypes are pretty varied.<br />
<br />
This could be done with a dtsx package that is executed from TSQL however I am running into truncation validation issues with most of the datatypes of the columns.<br />
<br />
Thanks in advance!<br />
TC72<br />

</div>
</div>


Experts,
I have a need to import a csv file that has the first row as column names into a table in an SQL2008 database. This must be done through the use of TSQL. This table will contain over 100 columns. The destination table column datatypes are pretty varied.

This could be done with a dtsx package that is executed from TSQL however I am running into truncation validation issues with most of the datatypes of the columns.

Thanks in advance!
TC72


Import CSV into SQL2008 using TSQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.