How can I programmatically get a count of exceptions after the data
pump has finished?
Thanks.
Josh

Hi,
I want to copy the data in tables from server A to files on the AS400. The
table structure on the server is the same as the file on the AS400(same
column names). In other words, the source and destination columns

When I copy/paste an existing package, it inherits all the IDs from the
exisiting package.  I generated a new ID on package level for the copied
package (but other level objects still share the same ID ), then I made some
modification on the new package, and let two packages run ...

What data is SSIS expecting to be stored in an environment variable when you
opt for indirect SQL Server package configuration? The documentation on this
is....incredibly sparse.

After upgrading to SS2005 from SS2000 I am not able to find where the legacy
DTS package logs are now located.  (I can no longer right click on a DTS
package to open the "package logs.")
thank you.

I created a config type 'Parent package variable' (ParentPackKey) in a parent
package and successfully passed it to a child package. I successfully
performed an INSERT into a table.  The correct ParentPackKey appeared in the
table.

We have a 2 processor box that we'd like to install SQL 2005 on. The question
is if we buy a single processor license, can we specify that integration
services use only one processor? I know you can tell the database engine
which processors to use, but I don't see anywhere in ...

It seems that there are only two books on SSIS
The Rational Guide to Scripting SQL Server 2005 - BETA preview
Professional SQL Server 2005 Integration Services by wrox
Has anyone read these or any other ones out there?

I was wondering if anyone knew a way to "preview" the results of a
derived column in SSIS, similar to how you could preview a transform in
DTS, without actually running the package.
Thanks,

I have a number of DTS's that are executed each morning via a Scheduled Job.
Sometimes I find that the Job has got "stuck" on a Step (DTS) and does not
"stop" until I manually stop the job myself through EM.
Question is: How can I give my DTS's a Maximum Expected Run Time?

I'm using SSIS for the first time but I'm no novice about unicode and
non-unicode.
This time I really don't see why SSIS is bothering me with a DT_STR to
DT_WSTR conversion problems.

I have a SQL Task, that has two seperate "On Success" Workflows coming from
it.
I want to know if there is a way of setting my first "On Success" workflow
to have priority over the second workflow. i.e. So One task runs before the

I'm having a problem with my DTS packages when they are run as
scheduled jobs.
Basically, I have a DTS that calls other DTS packages from within. When
run through enterprise manager, it all runs fine, all internal DTS

I'm trying to import user views from db to another. When I use the copy table
and views option and select only the views it appears to copy fine and says
so but the views don't show up in the destination. When I use copy objects
and select only the view it generates an error that ...

I am a newbie to SSIS.Need a solution to couple of issues I am
currently facing while developing ETL in SSIS
1) Under SSIS Package Folder I have defined mappings for 17 dimensions.
1st Dimension say Account has been Set up as a startup object.