I am trying to use the Flat File Connection Manager Editor to break a vendor
provided flat file into columns... this file originates from a mainframe and
uses fixed positions rather than delimiters. There does not seem to be an
option for this in the editor. Is there some way to ...

I import all txt files in a folder into the database with this code:
http://www.sqlis.com/55.aspx
I want to count the number of files in the folder and send an e-mail
if 0 files exist. How can that be done?

I'm trying to run a series of SQLIS packages which pull data from an
IBM iSeries server.  What is driving me crazy is the constant
disabling of my user on this server - the server is set to disable a
user on 3 unsuccessful logon attempts.

Is ther a dtsx specification that list all the dts elements and attributes?  
I find that visual studio hoses up my ssis packages sometimes and it would be
better just to edit in notepad.

I have lots of packages which are quite alike each other. Lots of tasks
in the packages are the same in each and every package. Is there any way
to get rid of the "duplicate code"?
I did some tests and moved the duplicate tasks into a new package and

I am getting funny results when populating a fact table through a
simple data import in SSIS. The target fact table has a composite
primary key. Here is the DDL:
CREATE TABLE [dbo].[FACT_CLAIMS](

Hi,
I used the build-in migration wizard to migrate a SQL 2000 DTS package saved
as a *.dts file to SQL 2005 integration, but can not find the location of the
upgrade package.

In SSIS 2005 after using a conditional split and then doing some
additional tasks on each of the work flow, how can the multiple
datasets be combined?

From a csv flat file in SSIS 2005 is it possible to import data only
where a particular value is in the data?
As currently I import the data and then delete the records.

The SSIS packages work fine so far,
but someday in the future I will have to change the Data Sources
if the servers will be changed.
To open the original files and update them - it looks as a very bad practice.

I have an SSIS package that uses config files. I noticed that everytime I
run the package in SQL I have to point to the config file. Is there a way to
keep package connected to the config file so when I put my job on a schedule
it can run without using user interaction?

Quick question - I created a test SSIS package that loads millions of rows
of data into a table and performs Lookup transformations and a few Derived
Column transformations. Nothing fancy or out of the ordinary. The
performance is absolutely horrible.

Hola, estoy haciendo un dtsx para tratar datos de distintas bases y
tal, quiero llegar  a controlar si se produce algun error para
notificarlo. es decir, que si algo falla pueda capturar el error y
enviarmelo al correo por ejemplo.

I'm creating a SSIS package that is connecting to my SQL database using SQL
Auth. I can enter in the password and ID for the connection manager but when
I try to run my package it fails and when I open the connection manager for
this database the PWD field is empty. How can keep ...

When using expression and constraint option using the precedence constraint
editor I receive following message:
Error at 11AA_to_Capacity_report: The expression "@MissingSectionCount > 0"
must evaluate to True or False. Change the expression to evaluate to a