I have a package that works great when I run it from the SQL2000 environment.
This job transfers data from SQl2005 table to a mainframe DB2 table.
After I migrated the job to SQL2005 and ran it (with'n th SQL2000 desiigner editor) it fails with the message
Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:The number of failing rows exceeds the maximum...
Bxitty
Last Activity: Mar 14 '08, 01:13 PM
Joined: Sep 6 '07
Location:
-
Legacy DTS job to copy data from SQL005 to mainframe DB2
-
Thanks..I got the answer..it was partly to do with the way I was declaring the objects...... -
Delete Excel worksheet
Hello all,
I am trying the below code to delete a worksheet using VB.NET..I amgeeting an error with the delete...any idea where this could be wrong..
Dim str_path As String
Dim str_name As String
str_path = "C:\Biju\SSIS\R eports\00002155 74.xls"
str_name = "Loss_Relat ed"
Dim appExcel As Excel.Applicati on
Dim... -
Excel and VB.NET
Hi,
I am trying to delete an excel spreadsheet with VB.NET in SSIS. I am getting the below error.
Error: The script threw an exception: Unable to cast COM object of type 'System.__ComOb ject' to interface type 'Microsoft.Offi ce.Interop.Exce l.Sheets'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D7-0000-0000-C000-000000000046}' failed due to the following... -
Excel and VB.NET
Hello All,
Can anyone of you provide information related to..
1. How to delete a worksheet from an existing excel spreadsheet using VB.NEt
2. count number of spread worksheet an excel spreadhseet using VB.NET
3. How to calculate the size of a spreadheet in KB using VB.NET
4. How to zip a excel spreashhet using Vb.NET
I have done all the above with VBA and my trying to do with .NET...
No activity results to display
Leave a comment: