I try to create my own SSIS package execution utility.
the command line utility (dtexec) doesn't provides enough control for us.
in fact to execute a package we must provide the password and we don't want
to give access to this password to the administrators!

In a SSIS package I need to run an OLE DB command against an Access
database passing in a value from the package to use as the where
clause and return a count value back to be used within the package.
How do you handle this scenario within SSIS?

I'll try and explain this the best I can.
We are using SQL Server table configurations to setup our connections as we
move packages to different servers (Development, UAT, Production).  For
example we have a connection to database A in our package.  We then create a

Someone help, please.
I have an SSIS package with a bunch of SQL to SQL data flow tasks.  Some use
T-SQL to do the export/import and some are literal table-to-table copies.  
The databases both reside on the same Server & same instance.  The package

I have an asp.net page which runs a SSIS package by doing
System.Diagnostics.Process p1=new System.Diagnostics.Process();
p1.StartInfo.FileName=
System.Configuration.ConfigurationSettings.AppSettings["FilePath"];

I upgraded SQL Server 2005 64 bit to SP2 and noticed that my main load
package runs 3 time slower with sample set of data. This package has over
100 steps and it runs usually 21 second. After upgrading it run over 60
seconds.

In DTS, enabling logging allowed for concise recording of step name,
start time, end time and duration of DTS package steps which was
stored in the DTS package logs.
I have been unable to reproduce the equivalent functionality in SSIS,

I cannot load a flat file date (format yyyymmdd) into a database table
date (format datetime) in DataFlow Task in SSIS.  I get various
overflow and truncate error messages, no matter what I try.
I have spent about a month on this problem, on and off, and I have

I want to use an XML as source but the destination would be 3 different SQL
tables. How do I do it?
Thanks
Jnanesh

I am trying to create a derived column that states the following:
if PSPUUN <> LB AND MUDMCF =1 THEN PSCNQT/MUCOFA
if PSPUUN <> LB AND MUDMCF =2 THEN PSCNQT*MUCOFA
ELSE PSPUUN

I am trying my hand at developing a custom pipeline component.  I have
the red SSIS book published by Wrox and I followed their string
reverse example very closely, only changing the name to GroupFilter
and some of the string reverse logic.  It compiles successfully but

I have problem updating one of the propery with expression. I'm trying
to change the "SelectedTables" property in a "Update Statistics Task".
It keeps telling me the result of the expression cannot be written to
the property. Most other properties work fine.

Question to the more experienced.
I need to implement a simple process of importing data from an excel
spreadsheet
into a SQL db by making a series of SPs calls. The first SP returns an ID

I have a directory on a server into which people will plop Access
databases. I need to iterate through every file in that directory and
import it to the SQL server.
I've got the iterating part down pat -- I have a Foreach loop

reading a column with char type from source .net-odbc return this error:
[DataReader Source [2032]] Error: The "component "DataReader Source" (2032)"
failed because truncation occurred, and the truncation row disposition on
"output column "ANF_NEW_CODE" (2144)" specifies failure ...