Host unlimited blogs, sites, forums for $4.95 only with this host

Exclude duplicates in DTS package

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by dorkygrin on 09 February 2010

fast database hosting

In the past, I’ve made DTS packages for MSDE (SQL2000). Looking for some guidance on the following project:
Need to develop a weekly process to update a specific column in a specific table in a SQL 2008 Express database. The column contains full Employee Names. Destination field is called PL5 and is PrimaryKey and it does not accept nulls or duplicates.
Source: XLS or MDB. Columname is “Fullname”
Destination Database Name: Personnel
Table Name: PL5
Column Name: Item (PK, varchar, no nulls)
Using DTS:
Despite finding out that you cannot save DTS packages in SQL 2008 express, I got it to work with the DTS install that was made for SQL2000. In SQL Server Mgt Studio under Legacy DTS, I can see and run the saved packages.
Can get FullName field from XLS spreasheet.
Excluded nulls by using “Fullname<>null”
Tried to insert that data to a column in a specific table. However, I get errors that indicate no duplicates.
Question: Is there a statement that can be used in DTS to compare the XLS to the target column so that only NEW records are transferred?
Maybe I should look at Stored Procedures?

Learnmore Microsoft SQL Server databases hereShould you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting

This entry was posted in Databases Bookmark this post and come back later for the best web hosting coupons.

This web hosting blog is proudly hosted with reliable Hostgator webhosting for only one cents through this hostgator coupon. If you're new here, you may want to subscribe to this web hosting RSS feed

-->