blogs.conchango.com

welcome to the conchango blogging site
Welcome to blogs.conchango.com Sign in | Join | Help
in Search
Blogs

SSIS Junkie

Connecting Windows Mobile to Vista

I've been having some fun and games this evening trying to get my Windows Mobile 5 smartphone to connect to Windows Mobile Device Center (the new name for ActiveSync) on Windows Vista but I've finally got it working and here's the secret. You just have to open up the following ports in your Firewall program:

  • TCP 990
  • TCP 999
  • TCP 5678
  • UDP 5679
  • TCP 5721
  • TCP 26675

Have fun!!

-Jamie

 

 

 

Published 17 April 2007 06:30 by jamie.thomson

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

El Guapo said:

I have the same table in 3 different databases. Exact same schema. Each of the 3 tables contains a lot of the same rows, but there are also some unknown number of rows which exist only in each of the different tables.

How can I use SSIS to merge the data back into 1 database?

If I just use the data flow task, I get primary key constraint errors because, as I mentioned, the 3 tables have a lot of the same data. So basically on each data flow, I only want to insert the unique records into the common table. Not all of them.

How can I do it?

Thanks

April 19, 2007 04:02
 

jamie.thomson said:

El Guapo,

The SORT component can eliminate duplicate rows. You should use that.

Please could you direct queries like this to the SSIS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1). That way you'll stand more chance of getting an answer and the information will be easily available for other people.

Thanks

-Jamie

April 19, 2007 06:07

Leave a Comment

(required) 
(optional)
(required) 
Submit

This Blog

Syndication

News
© 2008 - Any comments or statements made herein do not necessarily reflect those of Conchango.
Powered by Community Server (Personal Edition), by Telligent Systems