A simple question for those with experience in building custom SSIS
components.
How does one implement a true/false dropdown list in the properties
pane for a custom property?

I'm trying to schedule an SSIS package which has password protected
login information.
If I run it from the command line using dtexec, it executes OK but if I
schedule it, it puts authentication errors for the SA user in the Event

I have a procedure that select max value from table.The result of the
proc shld be stored in variable.Please let me know how to proceed as I
am new to SSIS.
Thanks in advance

Hi,
I would like to know what is the best way to use SSIS between the 2 options:
1 - In SSIS to use a SQL task to execute the job with a stored procedure
2 - Or to use all SSIS task like: lookUp, Derived Column, Aggregate, ..;

I've scheduled an SSIS package to run every night, but the package
always fails to run. As usual with SQL 2005, the error messages are of
no use in determining what caused the failure.
It simply says:

I have a PC which is on our office network, which has a .dbf files and one
.dbc file. The directory which has these files has been shared. I have no
idea of what version of foxpro files they are. I need to import it into SQL
server 2000 database.

I tryed to split data flow by Conditional Split Transformation.
If condition using integer, numeric or string values, it works fine.
By I face the problem using GUID values in  the conditional  - "The data
type DT_GUID cannot be use with bynary operator ==".

We use SS 2000 DTS packages a lot but very new in SSIS 2005, thinking of
upgrade to SS 2005.
We also have a third party code which we are thinking to replace with new SS
2005 if we can do one specific type of data load.

I'm sure this must be simple but after an hour searching I can't find
how to do it. I often see people recommending removing unneeded columns
from a transformation especially when you get the:
"Removing this unused output column can increase Data Flow task

Having trouble getting my SSIS package to use Fuzzy lookups on date of
birth.  The fuzzy part wants to compare strings not dates and won't give me
access to the SQL code to transform it on the fly.
Does anyone have a sample snippet they can share?

Is it better to use SSIS Task (like aggregate, sort,merge,..) or to import
all tables in the database, and only to use an Execute SQL Task.
It looks easier to use only SQL even if it's take more space !.
Thanks

Hey all,
I was wondering is there a Transformation or other method in SSIS that
would allow me to remove the top 25% and bottom 25% of records based on
a certain attribute (like Product Quantity)? The Percentage / Row

I have a package with a precedence constraint containing the
expression:
ISNULL(@endDate) == True
(I have tried other variations, of course, since ISNULL(@endDate) is

Expressions are awesome in SSIS and I use them a lot.
But they are also hard to find if someone else created the package.
Is there a way to see a list of tasks/connections using expressions in
a package, or a list of expressions and where they are being used.

I need to use Excel connection manager to import a xls file. MS Excel
is not installed on the box I am working on and the task fails with the
error:
[Excel Source [441]] Error: The AcquireConnection method call to the