JUST ADDING, DATE FORMAT MENTIONED IN MY previous post is the date which i had loaded in excel

Hi I am also facing similar problem.

I transfering data from Excel and for Date it is throwing error:

Error3Validation error. Data Flow Task: SQL Server Destination [13055]: The column "Review Date"...

Hi All,

I found the root cause of error, thought to share ..........

It is like DTS works irrespective of metadata. Column dataset and excel field Dataset mismatch is acceptable. But SSIs...

yes.......thats a good idea.............

Hey....... thanks for u'r continously help and reply...............thanks a ton

🙂

They want with minimum changes.............. any way I'll try that also.

But can u tell me that if My system is not having Microsoft Excel installed...............will any package work which is...

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

' Visual Basic ActiveX Script

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

Function Main()

Dim fso

set fso = CREATEOBJECT("Scripting.FileSystemObject")

'Creating Log File and assigning the log file to gv_LogFileName

...

Thanks for the reply........... but my problem is that it is not able to identify the file name and location. all paths are correct....but throwing error "Error Retrieving file name...

the script is as follows

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

' Visual Basic ActiveX Script

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

' (DefineTheGVs)

Option Explicit

Function Main()

Dim Stuff1

Dim fso

Dim fold

Dim pkg

Dim stpContinuePkg

Dim stpExitbadDirectory

Dim sFilename

Dim Ofwrite

' First thing we need to do is to check...

saw u'r post ........... i am also facing same problem? did u get any solution to this. even i am also not having experience in VB, .net. I am a...