What reporting platform are you using? You should parameterize the query and I'm sure whatever reporting platform you are using supports parameters.

The reason your query using ScheduledActivity.ScheduledStartTime = CONVERT(datetime,...

Duplicate post. Please put replies on this thread, http://www.sqlservercentral.com/Forums/Topic1769091-2799-1.aspx

I know you may not have control over this, but datetimes should be stored using a datetime data type, it makes things much easier. If your column is a...

Neo Aurora (3/14/2016)

---

Thank you very much for posting this, relating to the world of hassle that is SSIS package deployment, where we don't know the names of servers, users, or...

tskelley (3/14/2016)

---

Is there a reason you chose 64-bit instead of 32-bit? (or is this another article...) In other words, are there circumstances where one is more preferable than...

Without more information all we'd be doing is throwing stuff at the problem and seeing what sticks. Please read the first 2 articles linked in my signature and post...

There isn't enough information to provide what is going to be the right answer but are here are a couple of options:

/* This eliminates rows where advisor_id is null in...

Roust_m (3/3/2016)

---

Hi,

I have 3 production servers replicating data to a DR server. I am not planning to use the DR server for anything other than DR.

I did some reading...

I'd also recommend reading this [/url], since I wrote it.

ripas (3/4/2016)

---

Hello,

I want to transfer advisors from student_div_master to advisor_stud_table but because of null values I get an error.

advisor_stud_table has primary key. Is there any other way to copy some...

TomThomson (2/27/2016)

---

Jack Corbett (2/27/2016)

---

Ed Wagner (2/27/2016)

---

Having recently been on the interviewing end of dealing with recruiters I can say that modifying a resume is a common practice. ...

Is one result set returning 2 columns and the other only returning 1 column? That would explain the error.

I think your EST needs to be configured like this:

Notice I have 2 results being returned.

And then your For Each Loop need to be configured like this:

Then you don't even...

Steve,

Like Hugo I'm not sure I understand what you are trying to accomplish. So let me provide an example of what I think you want to do. I...

Is the error a SQL Error or an SSIS Error?

Is the @user variable you mention the actual name of the variable you are using in the package? How is...