Then I guess that there is some sort of version issue (accessing SSIS 2014 from SSMS...

melinda.savoy (3/28/2016)

---

Sorry for the non-clarification. I've got SQL Server Management Studio version 2008 R2 loaded on my laptop.

When I try to "ADD" in my object explorer Integration Services for...

What do you mean by this, please? What is being 'added' to what?

Here is your query again, reformatted to help others:

SELECT dbo.Systems.SiteNumber

, Derived_Policy_Audit_Latest.PolicyID

, dbo.PolicyAudit.ProductCode

, ...

matt 25763 (3/27/2016)

---

The scripts are used to generate client databases. I have a software as a service product which runs on some servers. Each server holds about 25 to...

May I ask what the purpose is behind these scripts? Are you using them to generate a dev database, or something similar? There may be other ways to do what...

In SSMS, if you go to Tools / Options / SQL Server Object Explorer / Scripting and set 'Check for Object Existence' to 'false', does that fix it for you?

I have my SQL Prompt 'Format' settings configured to align to my company's standard. Whenever I work on any code, CTRL-K/CTRL-Y gets pressed first. I want to write and read...

That's the way it does work for me. I suggest you go through your SSC user profile settings & see whether the option is there somewhere.

sqlfriends (3/24/2016)

---

We have a data warehouse SQL server and it has a lot of ETL SSIS running nightly on the server .

Currently it has 8 cpu with 16 hyperthread, 96...

georgheretis (3/24/2016)

---

sorry for the Capital letters

so

is it possible to use in one step

update Reports set SSIS=1 where ReportID=51

EXEC msdb.dbo.sp_start_job N'D_Reports'

and in the second step

update Reports set SSIS=0 where ReportID=51

thie...

And, as an aside, THERE IS NO NEED TO SHOUT when posting messages here. We're nice people.

georgheretis (3/24/2016)

---

OK

IS THIS CORRECT IN ONE STEP

begin

update Reports set SSIS=1 where ReportID=51

EXEC msdb.dbo.sp_start_job N'D_Reports'

end

begin

update Reports set SSIS=0 where ReportID=51

end

BECAUSE I AM GOING TO USE A LOT OF ReportID'S IN...

Great. Thanks for posting back. And here's your link again, in clickable form:

http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

When you try this, are you connected to the SQL instance via Windows Authentication or SQL Authentication?