I am building a DTS package that will transfer data from an Oracle
server to a local MSSQL server.  I have the data transformation task
almost complete and working well, but the SQL query still needs to
take a "batch" string parameter.

I am trying to download product data from a supplier to put into an
online store.
The supplier gives me a list of warehouses, and i can only download
from one at a time.

first of all, let me state that I'm new to SSIS. I've been successfully
using DTS for quite some time, but now want to change over to the new
version.
I was surprised to find out that I can only once assign a source column to

I have a DTS package that connects to an Oracle Database and pulls some
information from it with a SELECT query. I then take the results and place
them in a table on the local SQL server.
The DTS package has been wroknig fine for over a year, but there was an over

When another user try to work with my DTS he receives the following message:
"only the owner of dts package 'MyDTS' or a member of the sysadmin role may
drop it or any of its versions"
How could I let him work with it without making him a Sysadmin? (For

I have a dts package that works fine when I execute it directly. However when
I schedule a job to run it it fails on the 1st step. The first step ftp's a
file from one network folder to another. If it is a rights issue what account
do I need to give the rights to, and what rights ...

When retrieving a dynamic properties task in .NET the assignments collection
is set to null. Is this a known bug, or is there something special that needs
to be done to get the RCW to load this collection? Thx.

Just wanted to pass on some information regarding SSIS that can save you some
pain down the road...the Fuzzy Lookup feature of Integration Services is not
supported on the Standard Edition of SQL2005. What makes this sort of a
"gotcha" is that you can open BIDS (Visual Studio) on ...

Good Morning,
SSIS in SQL Server 2005
I tried to assign a value stored in a variable to the flat file source
connection using a script task as below and received the following error

i have a package that picks up xls file from a specific directory, puts it
into working directory. here is the problem. all files droped will have
worksheets named diferently in order for me to read it i need to have the
same name my excel read task is trying to read the sheet. i ...

Hello, hope somebody can help me out!
In 2005 I created some data views on SQL Server 2000 and used the DTS Export
Wizard to set up 4
local packages which were scheduled as Jobs to run on a daily basis. These

Is it possible to have a package (or any other automated
functionality) that will UPDATE a table as opposed to INSERT. This is
something that I have cared to do numerous times but for the life of
me I can never get anywhere with it.

(SQL Server 2000, DTS)
I have a parent package that includes a number of child packages. Each
child package is an Execute Task package.
I declare the global variables (e.g. SOURCE, DESTINATION) of the

I'm importing a text file into a table using the DTS Transform Data
Task.
How can I get the number of the imported records?
The global variable @@ROWCOUNT is equal to 0 in the next step (Execute

I have a job that needs to copy a file from a network share to the
local server. I'm using a FilesystemObject.Filecopy script and it
works ok when executed under my admin account that has access to the
network share. The problem I'm encountering is when I schedule the