doh

Open BIDS, and select Tools > Options. On the menu on the left select “Business Intelligence Designers” then “Integration Services Designers”. In the Script box in the...

3.51 is the version of the Jet driver

http://www.devx.com/tips/Tip/13652

yeah but are the column names changing day on day for the same worksheet?

and what is asp talking to? just go there and cut out the middle man?

are the column names changing within the same sheets?

where are all these crappy spreadsheets coming from 🙂

sounds easy enough to do in vb

you just need to paraterise the routine, get a for...each loop to go through the folder and then call the routine??

ah, good point

but i've only got read only on the oracle server

i've actually solved it by hacking the sql down (fun!)

i'd still like to know if the limits of SSIS...

erm...not sure why you are tinkering in xml

to add a DLL to the references, you need to

a) find it

http://social.msdn.microsoft.com/Forums/en/netfxsetup/thread/c9e83756-4ae2-4ed4-b154-1537f3bb3a22

not sure which version of windows you have, so will...

http://www.simple-talk.com/sql/ssis/passing-variables-to-and-from-an-ssis-task/

usually lock and unlock them

Dts.VariableDispenser.LockOneForWrite

vars.Unlock()

sort of thing

how about setting the network permissions to read/execute?

the lack of write means no LDB can be generated and the MDB is opened exclusively without one

try it in a batch file

then you'll know whether it's SSIS or a file thing, like network permissions

does it work in BIDS on the server or did you run it...

why can't you use the SP as the SQL of your data flow source and use an Excel destination?

how about

Postcode = Row.Postcode.ToStr

?

just answered a similar one here

http://www.sqlservercentral.com/Forums/Topic852934-364-1.aspx

use a config file 😉

ha...

derived column then? same principle as my sql