I have a table from which I would like to extract 3 text columns in a copy
column data transformation task. I am getting an error: Unspecified Error.
The max error count is set to 0. The SQL version is SS2000 SP4. The relevant
column schema follows.

I would like all records inserted into a database table to be copied into a
text file. (A 3rd party application will move this file and import the
records into another database).
I've seen how to create a trigger to copy inserted records into another

Can anyone please advise what i am doing wrong, I am trying to pass
variables to a DTS package using the following stored procedure, but the
variables do not look available in the DTS package (********* sensitive
information removed)

Can i know where can i find any good DSO scripting examples other than MSDN
site

I am not a developer. I am SQL Admin. I want to write an SSIS package. The
package should go and query msdb databases of all corporate SQL servers for
backup status. I can create a table where I can store SQL server names of all
SQL servers. What I would like to know how in SSIS ...

Hi...
I work with xml files, I use a foreach loop for process them.
I want to save the xml data into a table...
I can use this query:

I want to use SendMail task to send an email - only if data exists in table.
easy enough, however to check if data exists I have to go to data flow, how
do i return to control flow that data exists and yes - send an email?
tia,

I have a boolean type variable - pIsExists
I created an Execute SQL task to set this variable -
ResultSet: Single Row
SQLStatement: select 0 as test

I believe this to be a File System security issue but I can not get beyond it.
In my test I am using:  XML, to call a stored proc which executes  two .dtsx
packages.  One DTSX package "CreateExcel.dtsx" creates an Excel File from a
Sql Table.  The other dtsx package "RenameFile ...

I want to move some files to an archive folder once they processed - how can
I do this using dts package
eg. c:\file1yymmdd.xml -> c:\archive\file1yymmdd.xml
Thanks

Folks
I am trying to setup an MS SQL server 2005 DTS package to import data
from an As400 DB2 server.
I have the choice between 3 different (managed ?) providers

When I run this certain SSIS package ON the server its deployed to, then it
runs fine, no worries. When I try to run the package from my Management
Studio app (on my machine) while connected to the integration services
instance of that server, I get this error:

I'm fairly new to SQL Server 2005 Integration Services and I'm looking for
an online
SIS Glossary of Terms with a list of keywords used in SIS with their
meaning. Does anyone have internet links to 'Glossary of Terms'/Keywords

i have a foreach loop that loops through ADO recordset.
In that loop i have a execute package task (lets call it SubmitData), which
executes another package.
If at one iterration package SubmitData fails, foreach loop would continue?

I created a DTS package using import/export wizard in SQL 2005 SP2
eviroment, then I saved it on server. However, when I looked for it, couldn't
find it in SMO. It is different from 2000.
Thanks a lot,