I won't speak generally, but these are some things I ran into at my current project:

* you must know the URL to go to the repository. Sure, you can keep...

I wouldn't recommand the union all if you want to combine 12 flows. The union all is quite a nightmare in maintenance and since it is a semi-blocking transformation, it...

At my current project we use TortoiseSVN. It gets the job done, but there are some quirks/irritations.

Thanks!

In my personal opinion, I don't find the SQL statement that long 🙂

But if you really really want the SQL statement to originate from a file, you could read the...

You could try to convince an employer to hire you for an "internship" to start with.

Work there for 4 to 6 weeks for a lower rate (or none). This way...

Something that is not very clear for me on a first read:

do you have one configuration table for all the environments or has each environment its own config table?

If it...

http://msdn.microsoft.com/en-us/library/ms138020.aspx

and

http://lmgtfy.com/?q=ssis+error+logging

Ah, for deployment from my computer (locally developing packages) to the test server, I use BIDS Helper. Very easy with the GUI.

From deployment to production however, I use scripts similar...

Thanks for the link, very informative. However, at my current project I'm not allowed to install custom components, so yeah 🙂

Correct me if I'm wrong, but to me it seems...

Brandon Carl Goodman (4/23/2010)

---

Very nice. I have had to implement the check sum before. What I did was build a checksum value over the values of columns (in...

Brandon Carl Goodman (4/23/2010)

---

I apologize for my oversight da-zero. I agree with you a 100% with the functionality of components for the SCD. How about using a checksum...

Brandon Carl Goodman (4/23/2010)

---

I agree with ashokdasari, the MERGE is what I would do in this particular situation. I actually use the MERGE to handle TYPE II SCD in...

Yes, you need BIDS Helper 😀

Much much easier to deploy packages and it's free too!

That's because the datatypes of the output columns of your Excel source are probably still the same. (meaning, still DT_I4, while you need DT_WSTR). Either change it manually in the...