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 «««123

SSIS needed to run SSIS jobs? Expand / Collapse
Posted Tuesday, October 29, 2013 9:49 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, November 24, 2015 5:12 PM
Points: 596, Visits: 1,821
FYI, I have confirmed on two different instances of 64-bit SQL 2008 R2 SP2 that WITHOUT Integration Services installed you can run an SSIS Package from SQL Agent that imports data from text files to SQLServer. But you cannot import from Access files. I suspect the text import share componets with BCP which is part of the base install?

After running setup and adding Integration Services, as well as AccessDatabaseEngine (from ) , I can now run a SSIS package that imports from both text and Access files.
Post #1509440
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse