For years I have been accessing the DTS wizard through Entrprise Manager to
do casual copies of data between SQL Server 2000 instances on different
servers. Recently it has been failing, with an error message:
   Invalid OLEVERB structure

I'm trying to pass a global variable from a DTS package to the child packages
that it calls using ExecutePackage tasks.  I have selected the child's global
variable on the Inner Global Variable tab and I have selected the parent's
global variable on the Outer Global Variable tab. ...

Does anyone know if SSIS is included in the SQL 2005 evaluation version ?

Hello here
how can i transfer data of tables from server1 to server2 with SSIS while
the data on server1 is being loced by transaction?
can i set on ssis with (nolock)?

I would like to execute a ssrs report from within a ssis foreach loop but
there is no task especially for this so I tried to use the web service task
and connect to the ssrs web service but ssis complained about the ssrs wsdl,
does anyone know why and what I can do to fix? Thanks ...

I've just been presented a brief introduction to Integration Services
by one of the DBAs in our company.  Everything looks different... and
I'm not seeing much that actually looks "better".   I'm hoping that I
am wrong...

I am trying to move the DTS packages from SQL server 200 to Sql Server 2005.
I am unable to do this. Can someone please help me?
Thanks,

Hi @all!
I have got an application developed on 32 bit Windows. This application
controls and executes DTS  Packages on a SQL 2000 Server. So far everything
works fine.

Trying to learn SSIS basics and have a test Excel 2007 file - 4 columns and
one row of data: Text, integer, date, and text.  The date is formatted as
YYYYMMDD.  I've also tried YYYY-MM-DD.
The SQL table is being created via the package, and the EDate column is a

I am trying to populate the decimal values 0.000001 from the excel to
one of the field in my table using DTS but it is not populating as
0.000001 and it is moving as 9.999999999E
Is there any format condition I need to look?

Hi.  I've created my first SSIS Package and need to schedule it to run hourly
on a remote server.  Could someone tell me how this scheduling is done, or
direct me to a resource describing it?
It's my first SSIS Package and I can't seem to figure out how to do this.

Hi guys. Well, I think the main subject is self descriptive...
I have to copy many rows as fast as I can. Both databases (source and
target) are on the same server.
What is best performance?

I had a job to run a DTS package.
Do I have to reschedule the job after I modified the DTS package ?
OR
The SQLAgent job will pick up the new change from the DTS package ?

How can I create and traverse through the records of a dataset in DTSx package?
Should I create s script Task and edit the script, or try the ForeEach Loop
container with Enumerator, Foreach ADO Enumerator?
Is there any sample that I can start working with?

I have a SSIS package the makes a flat file connection to a file on
our network which has the same name and location everyday. I can
connect to when the package is executed from BIDS but fails with the
following error when executed as scheduled job