Viewing 15 posts - 7,366 through 7,380 (of 13,876 total)
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?
March 27, 2016 at 2:34 pm
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...
March 27, 2016 at 4:54 am
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.
March 26, 2016 at 9:51 am
sqlfriends (3/24/2016)
Currently it has 8 cpu with 16 hyperthread, 96...
March 24, 2016 at 11:12 am
georgheretis (3/24/2016)
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...
March 24, 2016 at 9:27 am
And, as an aside, THERE IS NO NEED TO SHOUT when posting messages here. We're nice people.
March 24, 2016 at 8:56 am
georgheretis (3/24/2016)
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...
March 24, 2016 at 8:55 am
scottcabral (3/23/2016)
thanks! that worked.here are the drivers in case anyone runs into same issue:
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html
Great. Thanks for posting back. And here's your link again, in clickable form:
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html
March 24, 2016 at 6:22 am
Still unable to manually run the package from SSIS Catalog from remote SSMS
When you try this, are you connected to the SQL instance via Windows Authentication or SQL Authentication?
March 23, 2016 at 2:43 pm
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.
March 23, 2016 at 2:41 pm
Probably because SSDT is a 32-bit client 🙂
March 23, 2016 at 2:03 pm
It really seems that the Agent service account does not have the necessary rights.
Are you using a UNC path?
March 23, 2016 at 2:01 pm
jasona.work (3/23/2016)
March 23, 2016 at 12:13 pm
SQL!$@w$0ME (3/23/2016)
Any thoughts on this.
Many...
March 23, 2016 at 12:11 pm
db8 (3/23/2016)
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"...
March 23, 2016 at 11:11 am
Viewing 15 posts - 7,366 through 7,380 (of 13,876 total)