In a SSIS script task how can you read the server name for an item in
the connection manager?

I write a config file for my SSIS package that contains my Start Date
and Cutoff Date variables. My package then reads these variables from
the config file and processes accordingly. Normally I will have these
parameters set to Yesterday and Today respectively. I can manually

I need to know if it’s possible to use SSIS to read and write IBM DB2
mainframe.
This question because at the moment I don’t know if the final result of my
project have an output with SQL Server 2005 or DB2.

I am attempting to write an SSIS package that extracts information
from a metadata table that  contains processing information for tables
in source and target databases
For each source column, the package will be executing a series of SQL

Created a simple SSIS package which includes one Analysis Services Processing
Task. I have created an connection manager object (cmo) and assigned it to
the AS task. Within the cmo I selected to use a specific user name and
password to log on to the server with. Tested this ...

I want to embed the SQL statement into ssis package.  How can I accomplish
this?.  My process is just import a text into a table and
delete all the records which don't have a matched.  Any suggestion should
greatly appreciate.

In my SSIS solution I have several packages.
When I run a certain package 'A' in BIDS, automatically another
package 'B' is also run,
even if 'B' has not been opened and 'A' does not run that 'B' package

I am receiving a run-time error when attempting to code a SQL
statement involving multiple parameters and a subquery in a Execute
SQL Task in SSIS:
1.  Insert SQL statement with a subselect that utilizes 3 parameters

I would like to limit importing rows with SSIS to those where the row type
is equal to "P" or "T"... and drop all others. How would I go about doing
this?
(Newbie question)

I have a simple flat file that contains data codes. I would like to
transform this into friendly info before inserting into SQL Server.
For example, the following transforms:
B=Hybrid

SQL Server 2000 SP2.
I can not load a simple flat file I created from an existing table without
all kinds of errors. I exported data to a flat file by choosing the default
settings except " for text qualifier.

I want to do such a thing:
Select * Into #T1 From..
Select * Into #T2 From
Select * From .. Inner Join #T1 ... Inner Join #T2 ...

I'm attempting to load an Excel Spreadsheet into SQL 2005, and 4 columns are
rather large.  The Excel Data Source picks DT_NTEXT for 2 of the columns, but
selects DT_WSTR 255 for the other two.  I use the advanced editor to set the
data types as DT_NTEXT for the External and ...

How come the C# version succeeds when the VB version fails?
What's different/wrong with the VB version?
BTW, I do not mind coding in C# but some of my colleagues do.
[code]

I have installed VS 2008 but do not see any of the BI project templates -
what am I doing wrong? They show up ok in my Visual Studio 2005 still ok.