We have a weird situation on an SQL2005 SP1 server. If we look in
sp_enum_sqlagent_subsystems we cannot see an entry for SSIS but we have SSIS
installed and running. Is there a way for us to get this subsystem entry
re-added or do we need to re-install SSIS?

Is there a way to force a DTS to move to a new record and attempt to insert
it in a table if it encounters records that violate a constraint? Or do not
fail it, instead just ignore all records that violate the constraint and
insert all other records that do not?

I am running SQL 2000.  I have a DTS that imports an Access database from a
remote source into my SQL server.  When I excecute the DTS manually it runs
perfectly, but when run as a Scheduled job I get the following error:
Executed as user: SQLSERVER\SYSTEM. DTSRun:  Loading...   ...

I have to create many formula on Excel spreadsheet. In now SSIS, and VBA
Excel but nothing else (i mean script or VB.NET). How can i use VBA in SSIS?
Thanks

I'm finding with SSIS 2005 that the most basic functionality--being
able to connect to datasources--is very difficult. I've tried to
connect to Sybase via ODBC and OLEDB and had different problems each
way. As a test I tried an ODBC connection to Access and it also had

I have a comma delimited file that has 200 columns in the first half of the
file and 226 in the 2nd half of the file.  I need to find a good way of
splitting up the file.  I am able to import the first half of the file just
fine by going into the properties and setting Last Row ...

I have a DTS package with many Transform Data Tasks. I need to move this to
a new server. Is there any way I can dynamically change it all?

I am having a lot more problems with data types in SSIS 2005 than in
DTS.
I have a global variable in an SSIS package which has a datatype, an
Execture SQL task which has a datatype, and a sproc which has a

I am importing a file into a database with a field that is ntext. (I can not
change the type of field in the destination.)The field I am having problems
with contains a lot of text. It keeps getting either truncated or is
completely missing, with no errors. I've tried using both ...

I need to move data from 15 tables from Server A to SQL Server 2005
database C, and then move data from 15 tables from Server B to SQL
Server 2005 database C. (For the record, Servers A and B are different
database products). The 15 tables on server  A and server B are exactly

I'm wondering if anyone knows an easy way to create a variable in SSIS
2005 that captures a running count of the errors occured on a given run
of a package.  So far, I've tried setting up "SSIS log provider for SQL
Server", then creating an Execute SQL Task:

My SQL jobs used keep their history on SQL Server 2000 MSDB. Recently all
jobs keep losing their job history. Each job only keep some history for very
short period.
Do you know why?

I've created a DTS package that works off a ini file on a server.  The
server is a development server.  Now I need to move it to QA.  I save the
file for the QA folks.  I've got an ActiveX script that takes the values out
of the ini file and creates the global variables to run ...

I've got a problem with my maintaince plans after moving the entire database
(including system databases) to a new server.
Every package fails with the following error message:
Executed as user: FINANCEDB2\SYSTEM. The package could not be loaded.  The

In my control flow I am returning a result set from the sql db
containing some words.  When I process incoming files I need to reject
rows if email column matches (not an exact match) any of these words.
I hoped I can create a script to loop each row through the recordset I