<div>
Are you saying .. that you need to import your CSV file into a SQL server express database table? If it's a one-time import, then you should be able to right-click on your database, click on tasks and then import, then follow the import wizard to import into an existing table or create a database table and dump the data.<br />
<br />
If this is going to be a re-curring import process, SQL Server Integration Services (SSIS) provides this type of functionality .. although I'm not sure SSIS is available with the SQL Server Express install.<br />
<br />
If I'm way off track from what you need, let me know. :)
</div>


<div>
<div class="content wysiwyg-content">
I have a &nbsp;csv file that i need to merge with my sql server express database using the data sources by the unique key field is there any easy utilities to help with this process <br />
<br />
thanks
</div>
</div>


I have a  csv file that i need to merge with my sql server express database using the data sources by the unique key field is there any easy utilities to help with this process 

thanks

Are you saying .. that you need to import your CSV file into a SQL server express database table? If it&#39;s a one-time import, then you should be able to right-click on your database, click on tasks and then import, then follow the import wizard to import into an existing table or create a database table and dump the data.

If this is going to be a re-curring import process, SQL Server Integration Services (SSIS) provides this type of functionality .. although I&#39;m not sure SSIS is available with the SQL Server Express install.

If I&#39;m way off track from what you need, let me know. :)

merge data with your sql server express database

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.