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: Wednesday, September 10, 2014 2:56 PM
Points: 160, Visits: 502
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