Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-15 : 09:23:14
|
| Sandra writes "Hello, I have created a DTS package that transfers the Excel data into the SQL Server 2000 database. I would like to enter some validation checking before the data pump task and to handle the errors.The first task checks the if the file is exist and if it does it goes on to the second task - Data Transformation task, but if the file does not exist there is another task with workflow OnFailure that writes the ErrorLog file. When I execute my package with file missing the package executes successfully and the WriteToLog file is not run. I use the workflow properties, ActiveX script to test if there is a file or not: Check for file and return appropriate result If oFSO.FileExists(sFilename) Then Main = DTSStepScriptResult_ExecuteTask else Main = DTSTaskExecResult_Failure end if Another question is if there is a way to check the excel column names with ActiveX script before Data Transformation task and to update them dynmically. " |
|
|
|
|
|
DTS package error handling