SSIS /DTS / ENTERPRISE SCHEDULE CAPABILITY

• reymon26

  SSC Journeyman

  Points: 86

  More actions

  November 5, 2010 at 8:35 am

  #228808

  hI,

  Please help me about this problem,,

  1) Does the SSIS can handel files such as VMS files from oracel,

  2) .bat files

  3) exe files made from vb.net

  4) text file creation to notepad

  5) wHAT im doing is to transfer all the jobs in aN ENTERPRISE SCHEDULE to SSIS or DTS? is it possible?

  6) from your point of view which is better ENTERPRISE SCHEDULE OR SSIS / DTS

  THANKS FOR THE HELP IN ADVANCE

• tmitchelar

  Hall of Fame

  Points: 3391

  More actions

  November 5, 2010 at 8:41 am

  #1247168

  reymon26 (11/5/2010)

  ---

  hI,

  Please help me about this problem,,

  1) Does the SSIS can handel files such as VMS files from oracel,

  2) .bat files

  3) exe files made from vb.net

  4) text file creation to notepad

  5) wHAT im doing is to transfer all the jobs in aN ENTERPRISE SCHEDULE to SSIS or DTS? is it possible?

  6) from your point of view which is better ENTERPRISE SCHEDULE OR SSIS / DTS

  THANKS FOR THE HELP IN ADVANCE

  1)Yes

  2)Yes

  3)Yes

  4)Yes

  5)Yes

  6) Not sure.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  November 5, 2010 at 3:04 pm

  #1247344

  An enterprise scheduler should run across multiple machines. SQL Agent can do a lot of what is being done here, but that's what you use, a SQL Agent job.

  SSIS is for building data movement packages. It could run a .BAT file or .EXEs, but it would run those as a SQL Agent job, and unless you need it bound in a package, I'm not sure why you wouldn't use an Agent job instead.

  As far as VMS files, if there is an ODBC driver, SSIS can import the data.

  If you look in Books Online, you will find more information on SQL Agent and SSIS.