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...

I tried this, both as the SQL login and as the AD account....

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...

Lowell (8/17/2015)

taybre (8/17/2015)

I've just checked the error...

I've just checked the error log and...

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',...

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',...

Looks like he needs help grouping users?

We need alot more info than just a topic subject to help you

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...

--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...

using below code as an example:

create table #temp

(

[id]int identity(7,1),

[col1] varchar(10),

...

@ skcadavre

That worked like a dream.

Thank you

:-):-)

taybre

I recommend SSIS, a single data push task, a source and destination for each csv needed. Eezpeezee :-P:-P

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,...

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...