we are using SQL Server SP 4 on W2003 box.
we have a source database otr and a destination newbus
we currently read from the source and insert into destination.
now we want to limit what we query from the source by joining it in a table in

On what type of global variable in DTS can I store a timestamp (varbinary(8))
value?
Thank you in advance.  

I'm having a problem using the Foreach Loop container that contains an XML
Task followed by a data flow task.
When I run my package in the debugger, the XML Task fails with the following
errors:

I have a SSIS package that was migrated from a DTS package.  If I rightclick
on the package & click run package within management studio, it executes
correctly.  If I run the package in a stored procedure using DTEXEC utility I
get the following error:

Is it possible to activate or deactivate a scheduled DTS job with a t-sql
script?
Thanks for some thoughts
Michel

I am going to have a stored procedure that will call and execute an
SSIS package. I was going to use the DTexec utilility but have not
found out how to call that utility from a stored procedure. Is the the
right approach or is there a better way? Is there an alternate way to

I would like to create a DTS package that will import a password protected
excel file into SQL.  But I get get an unable to decrypt the file error when
I try to link it to either a file dsn, or  system connection.  Does anybody
have any ideas on how this can be accomplished.

Maybe my doubt is very simple, but i did't find references how to solve this
problem that in SQL 2000 I've used dynamic properties.
The objective is to create a text file destination based in a query. But
each time that the package runs I want to create a file based on the actual

I created a package with is used several times in another package.  Because
of the number of times I changed the subordinate package, the file size grew
quite large.  To reduce it, I called up the subordinate package and did a
save as newfilename (with the same package name).  I ...

“GiUpdateRowCount” Global Variable Created DTS package
Update TableName
From TableName2
Where TableName.Col1    =     TableName2.Col1

I know DTS but am new to SSIS.  I am having trouble exporting records
that don't match from a lookup transformation.  I get the following
error:
Row yielded no match during lookup.

 When I execute the package manually (right click on the file, Open
With | Execute Package Utility), the package executes normally until it
reaches a line
'Information:  Execute phase beginning'.  At which point it seems like

whats the best way to identify whether dts is currently running or
not?(ms-sql 2000)
Cheers
DF

I have a large table and i am trying to find a way to import only the new
records into SQL Server 2000. Once the records are in the table they are not
updated so i can use the date and time fields to find what is the most recent
record that is not a problem. The problem is how do ...

ok simple question and maybe i don't even need the template. How do you
create a new dts package in 2005
Note: I have VS2005 pro as well as sql 2005 when i goto Sql server business
intelegence studio VS pro starts but no DTS (Data Transformation Project)