Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to migrate Scripting.Filesystem objects used inside ActiveX script to SSIS equivalent task/code?

April 26, 2017ActiveX equivalent migrate objects Script ssis Task Used

0

Posted

How to migrate Scripting.Filesystem objects used inside ActiveX script to SSIS equivalent task/code?

1 Answer

0

Posted

Generally developers use Scripting.FileSystem object in ActiveX script task to perform various file system related tasks (e.g. Copy file, Delete file etc.). In SSIS you can perform many file system related common tasks using File System task. You should find out the possibility of replacing ActiveX script using SSIS File System Task. If any task you performing using Scripting.FileSystem is not possible using File System Task (i.e. Check File Exists) then you can use Script Task in SSIS and use System.IO namespace to perform File/Folder related tasks not possible using FileSystem Task. You can perform any of the following operations using File System Task • Copy directory • Copy file • Create directory • Delete directory • Delete directory content • Delete file • Move directory • Move file • Rename file • Set Attributes (i.e. Set file to Hidden, ReadOnly, Archive or System) If your ActiveX script is using anything other than above listed operations then you might have to use SSIS Script