Is there a way to estimate the size of a database if you know the size
of text files that will be imported to it?

For example if I create a blank SQL database and import 1 text file,
which is 1GB in size, can I estimate how big the database will be in
GB?
Or if I create a blank SQL database and import 10 text files which in
total are 1GB in size, can I estimate how big the database will be in
GB?

Regards,
Ciarán

It is possible to calculate the rough size of the database based:

(the size of each row + size of each index row) * no of rows

Maximum row size is pretty easy to work out as long as you're not
using varchar/varbinary(max). I often find that total size decreases
from flat file format as numeric data is usually smaller than the char
size of equivalent length (e.g. '10000' = 5 bytes or 10 bytes if
unicode, whereas typed 10000 is an INT of only 4 bytes)

I'm pretty sure there are a number of articles out there on database
sizing. I'd suggest you google it as it's not really a DTS/SSIS
consideration, it's a DB Design issue.
Good luck!
J

It is possible to calculate the rough size of the database based:

(the size of each row + size of each index row) * no of rows

Maximum row size is pretty easy to work out as long as you're not
using varchar/varbinary(max). I often find that total size decreases
from flat file format as numeric data is usually smaller than the char
size of equivalent length (e.g. '10000' = 5 bytes or 10 bytes if
unicode, whereas typed 10000 is an INT of only 4 bytes)

I'm pretty sure there are a number of articles out there on database
sizing. I'd suggest you google it as it's not really a DTS/SSIS
consideration, it's a DB Design issue.
Good luck!
J

It is possible to calculate the rough size of the database based:

(the size of each row + size of each index row) * no of rows

Maximum row size is pretty easy to work out as long as you're not
using varchar/varbinary(max). I often find that total size decreases
from flat file format as numeric data is usually smaller than the char
size of equivalent length (e.g. '10000' = 5 bytes or 10 bytes if
unicode, whereas typed 10000 is an INT of only 4 bytes)

I'm pretty sure there are a number of articles out there on database
sizing. I'd suggest you google it as it's not really a DTS/SSIS
consideration, it's a DB Design issue.
Good luck!
J

It is possible to calculate the rough size of the database based:

(the size of each row + size of each index row) * no of rows

Maximum row size is pretty easy to work out as long as you're not
using varchar/varbinary(max). I often find that total size decreases
from flat file format as numeric data is usually smaller than the char
size of equivalent length (e.g. '10000' = 5 bytes or 10 bytes if
unicode, whereas typed 10000 is an INT of only 4 bytes)

I'm pretty sure there are a number of articles out there on database
sizing. I'd suggest you google it as it's not really a DTS/SSIS
consideration, it's a DB Design issue.
Good luck!
J

It is possible to calculate the rough size of the database based:

(the size of each row + size of each index row) * no of rows

Maximum row size is pretty easy to work out as long as you're not
using varchar/varbinary(max). I often find that total size decreases
from flat file format as numeric data is usually smaller than the char
size of equivalent length (e.g. '10000' = 5 bytes or 10 bytes if
unicode, whereas typed 10000 is an INT of only 4 bytes)

I'm pretty sure there are a number of articles out there on database
sizing. I'd suggest you google it as it's not really a DTS/SSIS
consideration, it's a DB Design issue.
Good luck!
J

It is possible to calculate the rough size of the database based:

(the size of each row + size of each index row) * no of rows

Maximum row size is pretty easy to work out as long as you're not
using varchar/varbinary(max). I often find that total size decreases
from flat file format as numeric data is usually smaller than the char
size of equivalent length (e.g. '10000' = 5 bytes or 10 bytes if
unicode, whereas typed 10000 is an INT of only 4 bytes)

I'm pretty sure there are a number of articles out there on database
sizing. I'd suggest you google it as it's not really a DTS/SSIS
consideration, it's a DB Design issue.
Good luck!
J

It is possible to calculate the rough size of the database based:

(the size of each row + size of each index row) * no of rows

Maximum row size is pretty easy to work out as long as you're not
using varchar/varbinary(max). I often find that total size decreases
from flat file format as numeric data is usually smaller than the char
size of equivalent length (e.g. '10000' = 5 bytes or 10 bytes if
unicode, whereas typed 10000 is an INT of only 4 bytes)

I'm pretty sure there are a number of articles out there on database
sizing. I'd suggest you google it as it's not really a DTS/SSIS
consideration, it's a DB Design issue.
Good luck!
J

It is possible to calculate the rough size of the database based:

(the size of each row + size of each index row) * no of rows

Maximum row size is pretty easy to work out as long as you're not
using varchar/varbinary(max). I often find that total size decreases
from flat file format as numeric data is usually smaller than the char
size of equivalent length (e.g. '10000' = 5 bytes or 10 bytes if
unicode, whereas typed 10000 is an INT of only 4 bytes)

I'm pretty sure there are a number of articles out there on database
sizing. I'd suggest you google it as it's not really a DTS/SSIS
consideration, it's a DB Design issue.
Good luck!
J