Do you want to move data from Staging to Production or vice-versa? How are you identifying changed data...or is that what your question is? We need a bit more information...

This error message means that you are trying to run a 2005 SSIS package in a 2008R2 environment; is that the setup you have?

If you run the Package Upgrade Wizard...

Just one thing to watch out for DaveDB, the code above relies on your instance having Sunday as the first day of the week. That might not...

Ok, but your initial requirement was to run 3-4 copies of hte package at the same time; that's what I've been trying to give you a solution for. If you've...

I am not sure what you mean by your question.

Package configurations can be used to configure connection strings for the Connection Managers contained within your packages and those package...

Phillip.Putzback (1/14/2014)

---

Unless I am misunderstanding where you are running dtext from. Is it possible to have the sql job run dtexec to call the master and then the master call...

Can a master package variable value be overwritten at runtime using the /SET option? I've never tried, but I see no reason why not in principle. If so then that...

Koen Verbeeck (1/14/2014)

---

Option A doesn't seem directly to be a good idea, as this requires two surrogates keys in the fact table. However, only one of those two can be...

Yes, if you have 3 steps in a job then they will execute serially.

It is possible to overwrite variable values contained in a config file at runtime by using the...

My instinct would be your option (A) because, from what you have said, Products are Services are different entities. What other attributes beside Description does a Service have and what...

Phil Parkin (1/12/2014)

Your error message suggests that you do not have the correct (or any) version of SQL Server Data Tools (SSDT) installed - please check that. It's not called...

So are you asking: "why does it take less time for SSIS to write data to a table than it does to export it to a .csv file?" ?

You could set a Breakpoint in your Script taskand step through the code until you encounter the error, possibly.

You may not be returning a row count, but you must be returning some rows using a SELECT statement, right, otherwise your Resultset will always be empty? All you need...

Yes, you can do that. What is your Execute SQL task doing? If you are returning a count of the rows in the ResultSet as part of the SQL task,...