For a SSIS package that is created in a development environment, how do
you transfer it to a test/production environment?

I have basic SSIS package which I am trying to run a SQL script.
The package has a data source and data source view to a SQL 2000 server
using OLE DB. It has a SQL statement which parses within the tool but
when it executes it shows the following error message.

Using SQL 2005 sp1 or sp2 I can't get a Raiserror  ti FAIL a ExecuteSQLTask
if a stored procedure is present.
Eg
The below should raise error and fail the task but will not.

When I try to import Access 2007 database (.accdb) file to SQL 2005, I
receive the following error message:
TITLE: SQL Server Import and Export Wizard
------------------------------

TableA
Col1 UniqueIdentifier
TableB
Col1 varchar

I save my SSIS package in SQL Server.
How do I edit or run it?

When using SSIS in 2005 to import text files SQL Server has a certain
array of delimiters that it can recognize out of the box (so to speak).
Tab, comma, line feed characters and a few others are fairly standard
and easily configured column delimiters.

In the Execute SQL Task Editor, whenever I want to use a parameterized query,
when I go to the parameter mapping tab and I click "Add" the editor closes
itself.
I tried resetting the IDE settings but nothing happened.

I am running following
dtexec /f C:\Package.dtsx /conf C:\OLAPConfig.dtsConfig
It looks if my config file has wrong values at run time my package still
runs using design time correct values but I want my package to fail if config

Sorry if this is a dumb question or if I am handling this incorrectly, but I
have an SSIS package where it executes a SQL task (runs a stored proc).  I
have a Send E-Mail task that runs if the SQL Task fails.  I want that Send
E-Mail task's message to include the SQL error code ...

Scratching my head here. My package is reporting success after a
sequence container has finished successfully, even though there is a
precedence constraint from the container to another sequence container.
The scenario:

  I am having difficulty in returning a value from a stored procedure
into my SSIS package with the Execute SQL task.   The stored procedure
returns a single integer number and I know that the procedure works
because I tested it independent of SSIS.

I have a foreach container that building a collection of files in a
directory stored in a variable I call FileName.
In the foreach loop, I have script task that I want to pass that
FileName variable to. So I presume I pass it as a ReadonlyVariable.

The scenario is:
One VS2005 solution, in which is a WindowsApplication project and a
Business Intelligence SSIS project (a package).
The package uses an OLE DB connection manager, named "SourceDB", which

I have to merge 2 flow but I have to do a between comparison.
in the flow 1 I have a date (called dateid) in the flow 2 I have my
startdate and enddate.
so I need the content of the flow 2 when the dateid is between startdate and