Merge join is case sensitive. This is my guess as the culprit if you are joining on non-numeric columns, since a lot of sources aren't case sensitive. You...

Add a precedence contraint to your package and check your rundate versus the date contained within your file. If the date in your file is greater than 3 months...

You can use the same dimension for multiple fact tables. These are referred to as conformed dimensions. In fact, this method is preferred versus recreating the same dimension...

Oval. Definitely Oval.

This is...

Deleted comment.

da-zero (11/19/2010)

---

tmitchelar (11/19/2010)

---

The third way would be to click on the properties of the data flow task from the control flow and use and set your query there with your...

This is soley based on personal preference, but I would create four separate packages...one for each table. I like having the option of being able to rerun tables individually...

I'm guessing there is a datatype issue. I would suggest setting up a error output to a text file and maybe a data viewer on the error path.

You could actually do it one of three ways. The first way would be like above where you are setting parameters and then using ? in place of your...

The name of the file will be stored in a variable that gets set in your Foreach Loop. Create a second variable that is a substringed version of that...

princa (11/15/2010)

---

So I searched again, which it might be the case that I developed the SSIS package on BIDS 2008 which by default demands SQLServer 2008? and I did try...

Thank you for that article! It helped clarify some of...

princa (11/12/2010)

---

Thanks CEWII & Tmitchelar, I will definitely have the Environmental variable, which is much easier for management.

My problem is:

1. Set the connection string during development stage in VS...

I would also recommend using an environment variable if you are going to be switching your packages between servers often. Then you could store the package configuration file wherever...