As a very new user, I am investigating whether we can use TestComplete to automate someof our file loading from legacy systems into our main accounts system. At the moment we manually copy a file to an int_in folder, run an SSIS package to process the job, and then log in to the accounts package and run a concurrent job to process the data from the tables. We then check the customers and/or invoices & credits loaded.
I am struggling to think how a test tool could do all this as my experience has been mostly with straightforward record/playback within an app.
The file copy can be done using the utilities object. There is a Utilities.CopyFile function that will copy a file or files from a source to a destination and return the number of files copied.
For running the SSIS package, you can probably instantiate the WScript.Shell object to execute the application at a command line. If the app does not execute at command line, you could put it into TestedApps and call it there with any necessary parameters.
You should then be able to script the the accounts package work and checkpoints from there.