Viewing 15 posts - 1 through 15 (of 21 total)
SOLVED:
Although I couldn't get the job to successfully execute the SSIS package, I did get the job to execute a TSQL statement containing xp_cmdshell.
I had to grant execute on xp_cmdshell...
HTH :-):-)
taybre
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 17, 2015 at 2:18 pm
Lowell (8/17/2015)
i believe if you set the owner of the job as your AD account, it would work.
I tried this, both as the SQL login and as the AD account....
HTH :-):-)
taybre
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 17, 2015 at 11:46 am
I changed everything to run on the AD.
The connection in the SSIS package = Windows Auth
Job = Windows Auth
Run as = proxy (using credential which is set to Windows...
HTH :-):-)
taybre
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 17, 2015 at 10:07 am
Lowell (8/17/2015)
taybre (8/17/2015)
GilaMonster (8/17/2015)
Look in the SQL error log (the instance you're trying to connect to). What's the full login failure message from the error log?
I've just checked the error...
HTH :-):-)
taybre
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 17, 2015 at 8:36 am
GilaMonster (8/17/2015)
Look in the SQL error log (the instance you're trying to connect to). What's the full login failure message from the error log?
I've just checked the error log and...
HTH :-):-)
taybre
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 17, 2015 at 6:30 am
My apologises, I forgot to include "size"
New source data =
create table sourcetable
(
[Marker] varchar(3),
[Country] varchar(2),
[Location] varchar(2),
[LocationName] varchar(10),
[Size] varchar(2)
)
insert into sourcetable
select 'IMP', 'C1','L1', 'Name1', 'S1'
union all
select 'IMP', 'C1','L2', 'Name2', 'S1'
union all
select 'IMP',...
HTH :-):-)
taybre
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 13, 2012 at 4:57 am
The problem with that is there is no fields!imp.value and fields!exp.value to use.
This is what my source table looks like
create table sourcetable
(
[Marker] varchar(3),
[Country] varchar(2),
[Location] varchar(2),
[LocationName] varchar(10)
)
insert into sourcetable
select 'IMP',...
HTH :-):-)
taybre
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 13, 2012 at 4:49 am
Looks like he needs help grouping users?
We need alot more info than just a topic subject to help you
HTH :-):-)
taybre
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 13, 2011 at 3:59 am
Hi Anthony,
Im assuming that you are working in SQL2008. I've experienced this problem before and discovered that in SQL2000, char(10) was the way to put text on a new line...
HTH :-):-)
taybre
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 6, 2011 at 8:43 am
--drop table #data
create table #data
(
id int identity(1,1),
num numeric(18,0),
cnum numeric(18,0)
)
insert into #data (num, cnum)
select 100,0
union
select 50,0
union
select 10,0
union
select 65,0
declare @cnt int
set @cnt = 1
while (@cnt <= (select COUNT(*) from #data))
begin
update...
HTH :-):-)
taybre
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 6, 2011 at 4:49 am
Can we increment Indentity field value with a sql ?
using below code as an example:
create table #temp
(
[id]int identity(7,1),
[col1] varchar(10),
...
HTH :-):-)
taybre
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 27, 2011 at 3:31 am
@ skcadavre
That worked like a dream.
Thank you
:-):-)
taybre
HTH :-):-)
taybre
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 24, 2011 at 9:01 am
I recommend SSIS, a single data push task, a source and destination for each csv needed. Eezpeezee :-P:-P
HTH :-):-)
taybre
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 23, 2011 at 9:56 am
I agree with Elliott, very odd and covered by my NDA, and to add to what Craig here are some generic tables you can use - CutomerInfo, CustomerTrxns, ExchangeRate, CustomerSecurity,...
HTH :-):-)
taybre
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 22, 2011 at 9:30 am
Are you using a single excel template that is used each time you export? I saw this 2(ish) years ago, and it had to do that the template has been...
HTH :-):-)
taybre
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 22, 2011 at 9:17 am
Viewing 15 posts - 1 through 15 (of 21 total)