I have many FoxPro databases to import into SQL Server and I am using
an SSIS project to import them. Small databases with small tables work
great using the DataFlow task. When I get to databases with tables that
are close to 2GB I have to work directly with the table (using a

Hii,
My case seems to be a strange one.
I want to populate data from from my xcel file to staging table and I am
using a  data conversion task in  between (since without this I am getting

Okay, I'm confused.
I'm setting up an SSIS package with a File System Task.  The object is
simple.  I want to copy over my Production db backup file to my Development
cluster on a nightly basis.  Since I use the database maintenence plan for my

I have a Data Flow Task component inside a package sitting on its own,
i.e. its not part of the normal flow of execution steps in my package.
What I want to do is to execute this Data Flow Task via script
(depending on the value of a package-scope variable).

I have a problem with SSIS, after an exception occurs in my "foreach
ADO enumeration" control the entire loop fails, that is -> the loop
does not go on to the next iteration.
I would like the loop to continue to its next iteration even though an

 SSIS seperates Control and Data Flow which I beleive Data Flow was
Transformation Task in DTS.  Data Flow has lots of new tools to massage data
like Sort, Aggregrate, Multicast, Audit, etc... and DataViewers.
 My question is I am not sure why i would want to do all the stuffs ...

I'm trying to set up a SSIS package to transfer our dev database onto a test
server for running unit tests, cleaning the db in the process. The DB is SQL
2005, SP1.
The problems I'm getting are:

I want a package to run each time whenever there's a file drop in the
specified folder. Is it possible in SSIS?
Thanks,
Jane

i have a problem importing a Column from Oracle to SQL2005 because there are
some (wrong) entries with a date < 01.01.1753. I think this can be solved
with a derived column, but to be honest, I dont get the syntax. So I need
something like this: If [DATE] < 01.01.1753 00:00:00 ...

I am trying to use the export wizard to export data from a SQL Server table
to a fixed width text file. The problem seems to be the row delimiter is
being ignored and multiple rows are being placed on the same row. This worked
fine in SQL 2000.

I need to access and modify an Data Reader data source using an ADO.NET
provider, and change the SQL query property at runtime. If this were an OLEDB
data source, I could specify parameters or set the SQL string from a
variable, but the Data Reader doesn't offer this option.

can anybody tell me the best way to load data fast using SSIS?  I'm trying to
just disable the indexes on the destination table before i truncate and then
load, but using the fast load option gives me an error saying that it was
unable to produce a plan because the clustered ...

Our data load processes use surrogate keys for data loads and I'm wondering
(really hope the answer is YES!!) if there is a better way to perform the
lookup. I'm using the lookup task to locate the surrogate key - based on the
natural key for that source - and if the lookup fails ...

Ok, I've searched high and low and cannot find a solution to a very
seemingly simple question.  I have a data flow task within my package
that contains source, transformation, and destination components.  I
created a failure precedence contraint from the data flow task to a

Folks,
Please advice me...
I have deployed  my package in sql server and it is running fine there.But
when I scheule it as a job, the job is failing.(No config file for the