One of the solutions to this was to upgrade to the latest patch. I checked to see and founds that we are at the latest in patches on our Server...

The error listed in the maintenance plan history under the activity of "rebuild indexes" properties, is as under:

[Microsoft SQL-DMO (ODBC SQLState: HY000)] Error 5180: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not open...

Thank you for your help. I should be able to use most of the ideas here for other data transfers. In this case, we are now trying to have the...

I just tried that and it worked perfectly. It skipped the first header line and copied all the data from the rows below, all 3000 lines of data.

I checked on the data in the file. While the first and second row first column are letters, the rest of the rows for the first column are numbers BUT...

Actually I used the above function. I created it as under:-

'**********************************************************************

'  Visual Basic Transformation Script

'  Copy each source column to the

'  destination column

'************************************************************************

Function Main()

 If left(DTSSource("FLAT FILE FOR SYSTEM#"),9) = "FLAT FILE"...

Just an update. Our server is just a SQL Server 2000 and not the Yukon 2005 Server.

That sounds perfect. If I wanted to use the xp_cmdshell for a net send instead of the xp_sendmail using e-mail, is there anything I would have to change in the...

I tried all the different permutations and still could not tweak the transformation using CDATE. But as per your suggestions, I downloaded the data per se without any conversion and...

The DTS package created using the wizard errored out with:

 'Type mismatched: CDATE'

Would this be because of the format sent, namely 'YYYYMMDD'. Do we have to convert this into something else?

Thanks

Currently when using DTS, I am doing so using the wizard. All I do is choose a source, namely the text flat file on the...