we are using sql server 2016. but first how to connect using stored proc to web url.

what does it mean to log into machine .  i have similar issue, it runs fine manually. but when schedule job it just hang there.

can anybody explain me in details

it it installed in shared drive which has production server path.

and its not failing , it jut keep running

yes I am using shared drive path , in my parameter

hi

my file is in excel 2007 coming, in my local machine I have 2016 installed, so will file save as 2016?

my connection string is :

so u r saying i need to develop in SSDT 2017 , i am deploying to 2016 server.

ok this is what i have noticed.

i am developing...

hi

thanks for the reply.

I changed my target server to 2016 and then create script task, but I m still getting same error.

one...

no I created in 2015 only , no upgrade

I want something liekt his

SELECT itemno,item code,closedate as new_date(in progress),close_date for open_date(approve)
FROM item a...

thank you.it works

here is my derived column
TOKEN([Copy of Employee Name (Last ,  MI)],",",2) + " " + TOKEN([Copy of Employee Name (Last, First )],",",1)

REPLACE(LTRIM(RTRIM([Copy of Supervisor Name ])),",","")

no there is no index in staging table

 I have 32 columns in excel

i have derived column and data conversion in between.

will it be reason?

sorry I m using execute process task but how can I get .gz extension here

ok lets say i want to dump into staging,what is the logic here