I have defined a new variable called DownLoadOutput in the scope of my
package and set the StandardOuputVariable to User::DownLoadOutput.  When
I run the package, it shows the command window because the WindowStyle
is set to Normal, but the command window invoked does not show ...

In Reporting services I want to execute a lot of reports pointing on a datasource1.
If something is wrong during ETL I want to execute reports from a backup datawarehouse using datasource2 .
Is it possible to change dynamically all  reports from datasource1 to datasource2, or ...

I would like your help with the Foreach loop container. Boy, am I having
issues with using it for looping through an ADO.NET dataset or what!?!? My
control flow has a data flow task that is executing a Data Reader task
(creating a .NET dataset for me). Now I go back to the ...

Well, I still get a lot of errors when trying to use the Webservice task in
SSIS. I've made a web service in SQL 2005 and it works fine when testing
from VB.Net. But it is not possible to call my method from SSIS using the
Webservice task. Get the following error :

Is there a way to create/set ExtendedProperties for SSIS packages through
the designer interface. I would like to have some way to add some simple
internal documentation to packages in a way that can be queried later. I can
use the Annotation tool but this is too unstructured and ...

Has anybody developed a ASP.Net app that interfaces to SSIS?  If so, what
was your experience?  Any pitfalls, tips, etc? We have a requirement to
launch and monitor SSIS packages via a web interface.

I want to use dynamic properties task to set the valuesfor the global
variables in SSIS 2005
In SQL 2000 this task is named "dynamic properties task". I can't found this
task in SSIS 2005 enterprise or standard.

I am new to ssis.  I think there are many wonderful objects to use.
however, I cannot believe there isn't one which allows you to update a
table.  is the only way to do a table update to write a stored procedure ?
thanks

I need to import data from DBASE databases to SQL 2005.
Is it possible in SQL 2005?
I imported the same data to a SQL 2000 before, but now in sql2005 I can't
make it in the same way.

I have another issue with performance, when SSIS is used with SQL server
2005 database engine as backend, it takes long to execute procedure but when
SSIS is used with SQL server 2000 database as backend, procedure execute in
expected time frame. (No delays are faced.)

I'm using Microsoft Jet 4.0 Ole DB Provider as the destination to export
from a SQL 2005 server table to a dbase III file. The SQL field type of the
data is BIGINT, and I want to go to a .dbf integer (N 9 0).
In my SSIS OLE DB Destination, in the OLD DB Destination Editor, my data ...

I have an Execute Command task in a control flow that should take the database
offline. The script works when directly used but when using a remote command
to affect it.
use master;

I have a Control Flow task (CF1), with a Data Flow Task (DF1) that takes a
text file and loads into a Datareader (DR1).
I am having difficulty figuring out how to use a 'Foreach Loop Container' in
my Control Flow (CF1) to iterate the rows of the data reader (DR1) using

Is SSIS available on SQL Server Workgroup Edition? Or at least enough of
it to create maintenance plans to perform scheduled backups?
Cheers
Kev

I am new to SSIS.  I have an SSIS package with a data flow component.  In
the data flow component I am processing a flat file that has a file date in
the header row.  I want to check the file date against the file date of the
last file processed.  If the new file date is the same ...