Forum Discussion

nidhi1's avatar
nidhi1
Occasional Contributor
14 years ago

Database table variable with csv file as data source

I have created a DB table variable and have used a csv file as an input to the variable. However, I see that this table variable is not reading correct values from the csv file. I want it to re...
tristaanogre's avatar
tristaanogre
Esteemed Contributor
14 years ago
The problem is that there is not a constant column length per row.  There are some rows that are longer and some that are shorter.



Consider a standard relational database, like a table in SQL.  You can't have in a single SQL table two rows in the table with a different number of columns.



What is the purpose behind the different row lengths?  Is there something you are trying to accomplish by using the CSV file as a DBTable object?