Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Connecting to Excel via Agent job Issues Expand / Collapse
Author
Message
Posted Tuesday, September 17, 2013 7:06 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 6:21 AM
Points: 328, Visits: 865
hey,

thanks for the reply,

yeah excel just seems a horrid pain, ive been reading up on SSIS frameworks and such, and wondering what people do to make sure the data gets in there.. (most of our Excel etls fail at least once a week due to column widths.)

if you cant garuntte the source file, do you make alterations to the load table? say make every col varchar(max) so you wont get errors loading it in then clean up after?

Post #1495491
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse