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?

Install the 32-bit drivers too, assuming they exist, then SSDT will use those.

When the packages run on the server, they will use the 64-bit versions.

Probably because SSDT is a 32-bit client 🙂

It really seems that the Agent service account does not have the necessary rights.

Are you using a UNC path?

jasona.work (3/23/2016)

---

I'd ask if it made me odd to be enjoying puttering around and tweaking a report in SSRS (with no guarantee that it will even be used) to get...

SQL!$@w$0ME (3/23/2016)

---

I am able to run the package from the server (manually run from SSIS Catalog not through job). But it fails when run from my desktop.

Any thoughts on this.

Many...

db8 (3/23/2016)

---

hi all

i need suggestion on this error

Truncation may occur due to inserting data from data flow column "name"

with a length of 50 to database column "name"...