Ignore the earlier post from a few minutes ago, I accidentally posted
it before I finished typing the question.
I am having a hard time understanding how one can set a package's
global variable value from outside the package.  I've set up a very

        i have a existing DTS package, however the execute SQL task
keep changing, instead, i will create one table to store those execute
SP name and using query to run for it. do you think the idea is
possible?

I have a SQL query against 190,000 row table in oracle which has 6 columns
that I need.   Importing this into a SQL Server table is taking 17 minutes.
I am using the OLE DB Source for Oracle.   When using a DataReader source
the process finishes in 12 minutes.

I am having a hard time understanding how one can set a package's
global variable value from outside the package.  I've set up a very
simple package that calls a stored procedure that copies data from one
table to another, filtering rows by a specific date.  I set a global

I have a stored procedure (SQL Server 2000, SP4) that inserts data into two
database tables. It is then set to run a DTS package using xp..cmdshell. The
DTS package exports the database tables to .txt files and then uploads those
to a DB2 database.

I'm importing data from within an Excel sheet to a sql table. It gives me an
error too many whitespaces after a certian number of records of import. I
only use 5 fields within the sheet. If I edit the sheet and delete
everything to the right of my last used field then re-import ...

i have to create a dts package that run once in a week by scheduling the
package using job. this dts package should move the records that falls within
that week to a access table. i havent created a dts package before. pls
assist me in creating a dts package to accomplish this ...

I'm inserting great amount of data into a table with several index and it
works very slowly. Is there any best practice on handling large table with
index? Should I disable the index first?
Thanks.

I have a field within a table defined varchar(25). The records look like
this:
1111_12132007.pdf
127_12142007.pdf

Sorry in advance for the frustrated tone.......
-Created an straight up Wizard Import of data from one system / database to
another.
-Figured out the scheduling a SSIS pkg thing.

I have a couple of table in my DTS package that sometimes are empty after DTS
despite Job is successful. When I run it again it can work.
Is there any way to put some verification code in DTS I could check if a
table is empty and I could run that particular step/task again?

Fellow developers.... I have an SSIS package that uses a stored
procedure to move data from SQL 2005 to an Excel 2007 package via a
stored procedure.  The data is arriving in the Excel file but... the
numbers are being stored on the sheet as text.  I have seen this issue

I have written script inside main() of a script task.
The code is written inside the Package's OnPreExecute event.
How come the script is executed twice. Since it is defined inside the package,
it should execute only once; right?

I have some SSIS Packages that gets data from different databases and loads
it onto my SQL Server Database.
Now my SQL Server is in another machine and my web pages are in different
machines. So I cannot go about executing a file system ssis packages.

How can I stop execution of a DTSx (2005) package programatically?
I created a script Task with the following code. However, there is no luck.
Thanks.
   Public Sub Main()