No Use From You!
I will manipulate the data once in my work table to enter it properly to production table. But, some of the data is not transfered to my work table since some rows in Excel contain numbers and letters like 505X and the record is empty in my work table.
Can you give some code examples or not?
webdev2
Last Activity: Jan 31 '07, 01:11 AM
Joined: Jan 30 '07
Location:
-
The DTS package will be executed through the ASP application and I would like to validate the data before it enters the database. Could you show some code or example how to do it. So far I entered the validation to check if the file is there and file name by creating ActiveX script task on first connection (Excel 97-2000) in the package.
function main()
sFile = DTSGlobalVariab les("gFileName" ).Value
Set...Leave a comment:
-
Create DTS package validation
Hi,
I have created a package that transfers transfers data from MS Excel file to the SQL Server 2000 database. I would like to add some data validation before the data is pumped into the database. How can I do that?
I would like to check the name of the file, column names (are there are spaces in column names), columns data types, the size of the file?
Thanks.
No activity results to display
Leave a comment: