I have one problem.
In SQL 2005 I have SSI package to export data to some excel files.
I have for loop container with some job (one of the job is generate file
name for exporting data and put the name into variable).

Hey there!
does anyone know a good site/documentation about the SSIS expression script
language (e.g.: used in Derived Columns)?
Thx,

Hello - I want to use the SSIS Foreach File Enumerator in a package that
loads files into one table, but also in that table update the filename
column to the name of the file
Thanks

Using Exchange Server 2003/Outlook 2003, we have created a custom Help
Desk form in Outlook. We would like the ability to link specific fields
from the Contacts Folder, in a drop-down list box if possible.  We are
far from knowing that something like this is even possible.  Would

I've got a big problem with SQL Server 2000 DTS and I hope that you
could help me.
I'm making a package (PKG A) calling an another one (PKG B) using à
Data Driven Query. When I run PKG B alone it works perfectly and there

Call me stupid, but I need help.
I'm converting from a Dbase5 file to SQL database.  I have a "dbase5"
connection for the source database and a "OLE ..SQL" connection to the
destination database.  Between the two connections I have a Data

I am looking to use DTS to manipulate data from a number of sources (access,
oracle, etc.) and am looking for some direction as to best practices and
gotchas that I should worry about.  Do people recommend using DTS or is there
a better way of doing this type of data ...

Using DTS i'm transferring 3 tables (Just select * statement ) from
database A and loading the 3 tables to database B repectively .
I need the tasks to be set like this:
1) There should be only one source and one target in the dts designer

Which compontent can retrive multi-tables result from a stored procedure and
save as XML which format same as ADO.NET dataset.writeXML?

we execute packages from our windows-application. Some packages take a long
time. Is it possible, to cancel packages programaticly?
Would be very happy for any comment!
Best regards

I am upgrading to SQL 2005. I have a VB script that calls a DTS package
(shown below). Is there a way for a VB script to call a SSIS package? I have
seen posts that mention adding a reference to
Microsoft.SqlServer.ManagedDTS.dll in VB.NET and calling

I have written many DTS packages to move data, I've never had to branch
in my workflow of tasks.
I'm creating a package which has a log table.  It runs four times a
day.  It will check the log table, if the package has already run,

Is there an easy way to migrate the mainframe databases, e.g.
ServiceCenter P4 or Model 204 to SQL Server.  In general, they all can
be called relational databases, but the data can not be migrated easily
by using the database utility tools.  Other than transfering to text or

I have to come up with a SSIS package to tranform data from oracle database
to our sql server database. This oracle db is managed by a third party , I
have been given 10 views from oracle so I can extarct information I need.  
How should I design my SSIS package? Do I have to have ...

I have a package that transfers data from a table in SQL Server to a
table with identical schema in Oracle. This package runs fine when run
from Visual Studio, but it fails when I set it up with a schedule in
SSMS.