Convert DTS ActiveX Script on File Naming

• Catherine Eibner

  Ten Centuries

  Points: 1364

  More actions

  April 24, 2007 at 11:05 pm

  #702295

  A really good description of how to do this can be found at:

  http://msdn2.microsoft.com/en-us/library/ms141214.aspx (this one is a little wordy - but gives you a detailed explination)

  http://www.sqlnerd.com/ssis_dynamic_dates.htm (much better with screenshots and is easy to follow)

  Keep in mind that Active X scripts have been included in SSIS for backward compatibility only - the new Script object replaces it for SSIS packages.

  Catherine

  ---

  Kindest Regards,

  Catherine Eibner
  cybner.com.au

• Paula-129590

  SSC-Addicted

  Points: 437

  More actions

  December 5, 2007 at 8:36 am

  #757358

  Hello,

  can anyone tell me how I can get this to work with an excel file? I have sucessfully used this ActiveX script for .txt files but it just wont work with .xls. Any help will be greatly appreciated.

  Thanks

• SSIS Guy

  SSCommitted

  Points: 1667

  More actions

  January 30, 2010 at 10:32 am

  #1111204

  Have you checked DTS to SSIS Migration tool called DTS xChange. It will handle many ActiveX releted issue and adds SSIS best practices to converted package.

  Check DTS to SSIS Migration Homepage http://www.pragmaticworks.com/Products/Business-Intelligence/DTSxChange