I am exporting data to a worksheet "Data". The worksheet "Result" is based
on the worksheet "Data", and has a pivot table.
When my users open the workbook, the pivot table gets refreshed which
changes the state of the file to "modified". When they close the workbook,

No matter how I place my objects in SSIS Designer
it won't save the layout. It always does Auto Format
and displays objects in one long column.
Really distrubing!

I open a new project and select Business Intelligence Projects, but i don't
see Data Transformation Project?
I am using VS2005 prefessional edition and Microsoft SQL Server Management
Studio version 9.00.1399.00

I have my packages organized into Solutions and Projects. When I click the
Start Debugging button on the toolbar, it starts up ALL PACKAGES FROM ALL
PROJECTS in the Solution.
In other Solutions, clicking the Start Debugging button only starts the one

Hi, I have a dts package which contains serveral steps and recently it has
been failing in one of the steps.  Is there any way I can trace why it fails?
Thanks,

Hi,
I have a dts package which contains several steps,  Is there any way I can
view what exactly each step does---the code for each step?
Thanks,

       I have a problem to dts a SQL table to an excel file.
from:      in data flow window, select a table, with one column, type varchar
to:          in data flow window, Excel destination, defining the excel
file's path

Hi, is it possible to split data (Space Separated Values format) in a column
into several rows?
I have a datasource/data extraction where a column has multiple values
separated by space. Those values should be in a row record by themselves. I

I have a series of fixed width flat files where the character length of
each record is 384.  The problem is that there is not a carriage return
after the ends of some of the records. There is research under way to
find out just exactly why this happens, but in the meantime, I need ...

How does one supply parameters to the SSIS call when using a .NET assembly?  
The code snipet I am using allows me to call a SSIS package, but I do not
know how to supply a parameter value for a SSIS package variable defined in a
package configuration with a parent package ...

I am trying to write a Windows Script file that will update an exisiting DTS
package.  The objective is to add an
additional mapping to the single transformation in a DataPump task.  The
existing transformation maps many fields,

Is there a way to execute a single DTS task using VBScript in SQL 2000?
TIA,
Alex

After installing sql server 2005 as second instance on top of 2000
instance
the dts package with ActiveX Script in 2000 instance hangs on execution
Does anyone experience such problems

I am trying to desing a series of SSIS packages that will read their
Connection Manager's connection string property from a package configurtion.
I anticipate databases migrating between servers in the near future and do
not want to re-design or re-enter connection strings, etc. ...

i want to dynamic dts package on dotnet
i can working on data from dynamic txt file to table in sql server .but
txt and table name is changeable.
can i do in vs.net ??(C#.Net)