I understand that DTSRUN is not supported in pure 64 bit.  Is it supported
under X64 (ie just runs as a 32 bit app) ?
thanks
Peter

I'm trying to import a small spreadsheet from Excel into a pre-created
SQL Server table. One column is defined as char(2), and the data
values are actually 2 digits. When the leading digit is non-zero, the
data transfers OK, but if the code is, say, '06', I get a null in SQL

I have a simple SSIS Package where I'm trying to move data from one SQL
Server instance to another.
When debugging the package in the SQL Server Business Intelligence
Development Studio, I keep getting the following error:

I'm sure i have a fairly simple question but i'm pretty new to SQL2K5 SSIS.  
I'm looking to see the best approach to normalizing some SQL tables I have.  
I want to extract the distinct types and then link the new type id back to my
account table.

I am trying to execute an SSIS Package and the SSIS package threw the
following errors:
1.) Executed as user: MyDomain\Administrator. ...00.3042.00 for 32-bit  
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  

I have an SSIS package which has for each loop, inside the loop 3 parallel
tasks should execute which are linked to another task.
Whenever I run the package, I get the following error in the Execution
results "The AcquireConnection method call to the connection manager

I'm wondering if this can be done.
DTS will export query results into a flat file, is it possible to continue
to email this flat file?
Thanks a lot,

I know how to use DTSRun.exe.
I also can redistribute only the files for DTS (as indicated in redist.txt) for
a normal client, which does *not* have the full SQL Server Client installed,
and then the normal user can execute DTS-packages. This works.

Without having to recreate this processing in SSIS, I have an existing
Access program
which I can run by commandline.  The batch file runs an AccessDB executing a
specific macro.

I have created a query to run in a .dtsx package.
I would like to parameterize it so that a user can input a value via the
Execute Utility dialog when the .dtsx package is double-clicked.
Any info would be appreciated!

We are running SQL server 2000 with DTS. We have a stored procedure which worked fine for quite a while. We had to change it recently and since then it fails when being run from a package. it works when run from embaracdero ro sql server enterprise manager, but when run from the ...

In my SQL Server 2000 DTS package i need to send e-mails to the list of
recipient. I am using xp_smtp_sendmail stored procedure.
When i send email to unavailable recipient i need to bounce back the e-mail
to the sender. But when i use the stored procedure the mail was not bounce

Hey folks...
   I have 7 DTS packages that connect to my remote SQL Server and transfers
data to my local server (back it up).
   I've made a job that runs these 7 packages every morning andby fridays

Is it possible to view all of the SSIS packages in SQL 2005 like we use to
be able to view the DTS packages in SQL 2000?  I cannot find anywhere in SQL
Mgmt Studio that displays the SSIS packages.
Thanks

We have a production SQL 2005 cluster running SSIS, and we need to restart
SSIS.  Is it safe to restart the SSIS service without affecting general
database operations and connectivity?