Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
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: Monday, September 26, 2016 1:48 AM
Points: 392, Visits: 1,119

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