Home Forums SQL Server 2005 SQL Server Newbies bulk insert vs openrowset RE: bulk insert vs openrowset
blackbird
Ten Centuries
Points: 1127
More actions
August 11, 2010 at 1:14 pm
#1205682
Couldn't that be done too via a SQL Agent job that runs every say 30 minutes or 1 hour? Just periodically look to see if there is a file and if so, then execute the rest of the SSIS package.