can we use 'if condition" in SSIS?
i.e if  true then "execute task1"
    else  "excetue task"'
If so how? any suggestion for working around case?

How can I retrieve the connections (connection managers) collections from
Custom Data Flow destination? ComponentMetadata.RuntimeConnectionCollection
is empty. I would like to be able to access all the connections defined in
the package from the custom data flow task.

I am trying to get a simple program to work in order to figure out how to
approach a large set of DTS tasks we're moving from 2K to 05.  I have an SQL
task that counts the number of records in a table, setting a variable (or
not, this is where I'm not able to make it work).

I need to create SSIS package which populates flat SQL Server table
from other SQL Server tables (SQL Server 2005).
Is there any performance advantage  in using SSIS Data Flow
Transformation (like merge joins, lookups etc..) or I can just copy

I guess I'm not understanding how SSIS configuration works.  I have an
SSIS package which I run under Sql Server Agent.  I want to setup
multiple jobs to run the same package with different configurations.
What I have so far is I used the Configuration Manager in BIDS, and an

I am trying to setup the connectionString property based on the
@[System::MachineName]  value.  The goal is to seamlessly move
developement code hitting a development database to production code
hitting the production database.

my SSIS packages consists of Data Flow tasks and Execute SQL Tasks.
I want to evaluate the result of each task to compose a status mail on
package completion.
Therefore I create package variables of type string that I assign to

Hi friends
Is there any DMV I can query to see port number a sql server instance is
currently using?
Many thanks

I have a problem in a SSIS package that uses a flat file source that is
placed in a directory over the intranet.
If I write
\\myServer\mySharedFolder\file.csv

I've noticed that SSIS saves paths to configuration files as absolute paths.
This way it's very hard to move a SSIS project to another location. I wonder
now I can easily deploy an SSIS project to a production server, where the
SSIS package will definitively be stored somewhere ...

I am new to SSIS. I am using Bulk Insert Task to load the CSV file to
DB tables.
I am having problem when the columns values has comma.
For ex:

We're on a 32 bit platform but considering going to a x64 platform. We have
both SSIS packages and linked server that communicate with an ORacle 9.2
database and with an AS400.
Is there a 64 bit driver that supports Oracle 9.2? Anyone successfully

I migrating a DTS package to an SSIS package. The DTS package had an Active
X script that is looking for a value of  1 or 0, if its 1 then the package
continues and if its 0 it errors out and sends an email. In the SSIS package
the Active X script is working but partially, meaning, ...

We have some stored procedures in SQL 2000 that are referencing to 2
different DBs in the same server, now that we migrated our servers to SQL
2005, due to performance improvements we created both Databases in different
servers. we

Here is some configuration background
SQL cluster 32bit, SP2
Issue: There are connections to the database within the package using user
accounts and passwords set while deploying the package to the SQL server