OH, so you are using SSIS.

why not use a data flow task to copy the data over instead of a script?

Eirikur Eiriksson (10/12/2016)

---

This looks entirely wrong to me, two instances of a parameter object with the same name in the same scope, using parameters in non-parameterized code, no command is...

you could do it as a stored procedure instead of a hard coded SQL command, but if you don't like that solution how about:

public static SqlDataAdapter InsertSQL()

{

SqlDataAdapter adapter = new...

The reason it is failing is that the variable doesn't exist on the MYSQL side. When you do the execute AT command, you are telling it to run that...

I agree with you Andrew.

It also doesn't help that every time I think I partially understand most of the features they add in something new or I find a feature...

Geeze. Sorry about that. Didn't...

That is a good question. Where I work we have 23 live SQL Instances, 51 test/development instances that are not always up (due to disk space constraints mostly) and...

Jeff Moden (10/5/2016)

---

bmg002 (9/27/2016)

---

Sean Lange (9/27/2016)

---

bmg002 (9/27/2016)

---

you are already doing that.

if you are using 3 values in the object declaration, you are declaring the database, the schema and the object.

so...

I recently took this test and pass first try.

The training I went with was uCertify.com. The price was decent and the content was exactly how I learn. They...

I could be wrong, but I think you are missing a few ;

I think the command should be:

sqlcmd -S %_var1% -d %_var2% -Q "DECLARE @status varchar(100); exec dbo.sp_RunSQLAgentJob @job_name =...

Sean Lange (9/27/2016)

---

bmg002 (9/27/2016)

---

you are already doing that.

if you are using 3 values in the object declaration, you are declaring the database, the schema and the object.

so in your case:

JIREM10.dbo.JIRABConcentration

JIREM10...

you are already doing that.

if you are using 3 values in the object declaration, you are declaring the database, the schema and the object.

so in your case:

JIREM10.dbo.JIRABConcentration

JIREM10 is the database

dbo...

Posisbly a dumb question, but are you enabling the broker? I don't see that in your scripts.

The other thing I'd recommend is to try sending a message outside of...

As a thought - are your database and SSRS instance on the same SQL Instance? If not, did you update both SSRS instance and your database instance?

it sounds to...

Another thought (that we hit in our shop) is if "Option (Recompile)" improves performance, your statistics may be out of date.

How frequently do you re-create statistics or just let it...