Difficult one, and that for a Monday.

Thanks Tom for the question.

If I understand it correctly, you point your connection manager to a dbf file, but also your source table (through a variable). Why is that?

The variable that you populate contains...

Well, since you are linking to the pics on your site, I still can't see them.

You need to add them in the attachment of your reply.

I'm sorry, but for some reason, your site is blocked by my company's firewall.

Can you post the details here? You can post pictures...

SQL Kiwi (12/12/2011)

---

The...

What do you guys think of this:

http://www.sqlservercentral.com/Forums/Topic1219134-364-1.aspx#bm1219795

I ask for more info, he gives a link to a site, which my company firewall immediately marks as suspicious.

CDC is quite a heavy weight solution....

Brandie Tarvin (12/9/2011)

---

DUH!Code

---

Code written by an experienced developer that defies all pre-existing code standards and the dev's knowledge skills by believing it can do something the developer knows is impossible.

Example:...

You are getting conversion errors because your date format probably isn't correct.

Check out the following topic:

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/65e1c7d2-5410-48d9-9bb1-964ea124d0d1/

You can easily check for NULL values using the ISNULL function.

What is your question exactly? Do you encounter any errors?

Why is there an entire Excel manual in your post? I'm not really going to be bothered by reading it all...

Pffft. TCP/IP, who uses that anyway? 😀

You can use change tracking to detect the changes and start off an incremental load to a data warehouse. Replication would just make the same database, while an ETL process...

Cadavre (12/9/2011)

---

Koen Verbeeck (12/9/2011)

---

It's get even worse. There's a channel with relative new movies (Green Lantern and Hangover II for example). Then there's another channel that plays the same movies,...

Cadavre (12/9/2011)

---

Koen Verbeeck (12/9/2011)

---

I recently moved to a new house and I took the opportunity to get me and my family digital television (it's fairly "new" in Belgium).

So now I...