Why does SSIS have both a connection manager and data sources?
Do you have a good learning source to recommend?

How do I add a config file to a SSIS Package?
How do I change source and destination server when I move a package from a
development environment to a destination environment?

Here is a newbie question regarding logging in SSIS.
When you run a package through the Execute Package Utility, a lot of good
information scrolls across the screen.  Is there a way to programacitally get
this information to automatically write to a flat file as well?

We have a DTS package we tried to convert / migrate to 2005. That didn't
work, well the migration showed it worked, but when running the package it
couldn't connect to the DBF file.
So we tried to create an SSIS package from scratch that does the same

Within a Devied Column Transformation Editor, how to build a date from parts
?
I have 3 cols 'year' , 'month' , 'day' , all numeric , I need to construct
the corresponding date.

has anyone done/compared the speed between incremental Load and Bulk
Load?
I have a table over 20 million records and it has been using bulk load
(crate table, load and rename) everynight.

I'm new to SSIS.  I've assigned a variable for Package called "Variable"
with a date time.  I would like to set the value buy pulling from the SQL DB
using a Select Statement.  Can someone tell me where I would do something
like this? The select statement is just a simple one"

I have a certain type of data-file with two rows preceding the actual data.
The first row is irrelevant. The second row is the column names.
In a Flat File Connection, I set "Header rows to skip" = 1 and I check
"Column names in the first data row" ...

Is it possible/advisable to use Visual Studio 2008 for a .dtsx project ?

I am having an odd problem.
In a pretty long SSIS package, I need to perform SQL 2005 Script Task
(the last Task!) after Data Flow Task irrespective of the result of
Data Flow Task. I used a blue arrow (Completion) from Data Flow Task

I have an SSIS VB.NET Script Task that is a starting task in an SSIS
package. Since the package could be executed either independently, or
as a step/task of a bigger package, VB.NET script needs to read the
name of the package. I tried to reference the system variable in 2

What license of SQL server do I need to have to run an SSIS package on a
production server? Will SQLExpress 2005 of SQLExpress 2008 work?

Ganhar dinheiro rápido e honesto
meu blog http://jet72.zip.net/

It works fine when I create and run logged in as the login that runs SQL
Agent jobs. I save the package and schedule and I get this message. I've
posted this before and seriously need some help.
DTS_E_PRODUCTLEVELTOLOW

We have had intermittent failures in SSIS packages running at night where
there is no indication of a problem until a low-level error occurs.
Re-Running the package works fine.
One thing I noticed is that there are a number of messages in the