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

I am trying to manually import data manually from a txt file to a table in
sql 2005 before I have a ssis package, is it possible like I did in sql
server 2000

Our origianl sql server 2000 database was created with COLLATE
Chinese_Taiwan_Stroke_CI_AS by someone, though we never store any Chinese
charater in database. In sql 2000 I never encounter any problem when we
import data from any flat files to any tables with this collation.

I'm having a difficult time trying to set up a Data Flow Task that will
export data into a MYSQL database.  After I create the OLD DB Destination and
try to create a new OLD DB Connection Manager and new Data Connection, I
don't see a provider  that is appropriate.  I do have ...

I need to check whithin an exists DTS source fild, i have the next code VB,
but it made error message is " No match the types : 'exists' "
Any help will be great
Thank you.

I created a package using the import wizard in management studio.
How do I modify/edit it?
I read that the DTS designer need to do the job, but how can I open the DTS
designer  from management studio?

I have been assigned to get an EDI written for enrollment of health insurance
from my HR system to a major insurance carrier; in fact, I need to create
about 5 Hipaa 834 files for other insurance companies too.  They want me to
send them data in a HIPAA 834 file format which I ...

I am using SSIS to import a CSV file into a SQL table.   How do I strip the
double quote marks surrounding the strings in the CSV file?  This seems like
a super-simple transformation but I can't figure it out.

What rights does a user need to connect to the server (2005) and
view/run packages from their client PC? Where are they configured?
Thanks

Please tell me whether its possible to open dts package using activeX
scripts(written in VB,js etc.) or by some other means but not thru Enterprise
manager directly. I need to specify logfile in each package on one of our
server. There are hundreds of packages on this server.

I've created a DTS package in SQL Server 2000 Enterprise Manager to
export the data in a table that has datetime fields using Task->Export
Data.  I've specified Excel 97-2000 as the destination file for the
export, and I've let the dts export wizard configure the mappings.

I have a simple DTS package that I need to insert records into an Excel file.  I want to start with a blank worksheet every time.  However, it is just appending to the file instead of overwriting it.  Here is how I have the package setup:
 1.. SQL task that uses "drop table" on ...

Ok I am trying to create a flat file connection manager using comma
delimited and " as the text qualifier.  The file imports into excel
properly, using import wizard in Sql Server 2000 it formats properly,
using import wizard or flat file connection manager in 2005 it does

i am new to DTS. i want to clone a access database based on the value of a
field that comes from the source table.
Can some one provide me some Tips in doing this with DTS package.

I'm fairly new to using SSIS, but I have learned how to download the
contents of a custom database to a local development server (both with SQL
2005). Now I am trying to learn how to download a copy of the membership
(all the tables related to applications, logins, roles, ...