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

Nightly package to import differential data Expand / Collapse
Posted Wednesday, August 28, 2013 2:28 PM


Group: General Forum Members
Last Login: Friday, August 8, 2014 10:45 AM
Points: 158, Visits: 495
Is there any way we can import differential data from an excel file to sql server as a job every night? any pointers would be awesome.

Post #1489416
Posted Thursday, August 29, 2013 11:59 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:05 PM
Points: 300, Visits: 810
Sure, it's just another source.

I would be careful of the data based on how it is being generated into that file, and provide yourself safeguards against importing the same file more than once.
Post #1489827
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse