Hi;
I have been trying to import several date fields from a text file into a
table where
the receiving columns are defined as small date.

I have a DTS package that deletes data from a table and then re-populates the
table with fresh data from our ERP system. The problem is this particular
table is linked to an access database,  and if a user has the table open in
access the DTS package will not delete the data, it ...

I am runnng into a situtation with a vendor who does not load their database
consistently. Sometimes a table is missing from their db. It is a lookup
table so is not critical. What I want to do is check for the existence of the
table in the source db, before I drop my local table ...

I have a package that has the following steps:
Transform data task : EXEC_usp_CreateDPDistancesHTM  (stored proc)
Connection properties : Create htm data file ( file created from stored
proc output)

Thanks in Advance,
I recently had to move about 200 DTS packages from one server to
another in a hurry.  The Source to Destination task worked fine with at
least one exception.  Many of the tasks refer to the old server in the

I need to dynamically build the columns used in a Transform Data Task (or
possibly a Data Driven Query Task). I understand how to read from the
registry and/or text files to dynamically set items, but I am not sure where
to start to build the source and destination columns in a ...

In honor of the help that I have recently received in this group, I thought I
would post the answer to a problem that had been plaguing me for a couple of
weeks in the hopes that this posting will help someone else.
Like many people, I am in the middle of upgrading from SQL Server ...

When I execute my SSIS package from SQL Server Agent job or DTEXECUI the
configurations stored in SQL server is not read. The connection to the SQL
Configuration is specified in the command parameters. When running profiler I
can see that the SSIS Configuration table is not ...

I am having trouble executing a DTS package from a SQL Job. It works OK for a
while but then starts failing with the following error message:
Executed as user: domain\SQLSvcAccount. DTSRun:  Cannot create COM Server to
load and execute DTS Package.  Error -2147221008 (800401F0):  ...

I need to periodically import a (HUGE) table of data from an external
data source into SQL Server, with the following scenarios:
1- Some of the records in the external data source may not exist in
SQL.

In my Dts Package Im trying to run a Data Transformaion using the following
select statements:
 tblICItemMaster.ItemNumber, tblICItemMaster.ItemID,
tblZStorItemLocation.Location, tblZStorItemLocation.Quantity, Getdate () as

I have SA permission on that SQL 2000 server. I can access that SQL server by
using Enterprise Manager from my PC. If I open a DTS package saved in "local
packages" on that server, I can open any DataPump connections.
But when I open a DTS package saved as .dts file on that server ...

I've been reading on SSIS for a couple of days now, and haven't come across a
mechanism on updating existing data!
My data source is a delimited flat file which i'll have to validate and then
plug into SQL server 2005.

I got a package with a Script task(VB) that runs OK when executing under
Stored Packages, File system but fails(stays "yellow") under SQL server Agent
Jobs. I've secured the package with "EncryptAllWithPassword". I guess it
might be a security issue in Sql server agent. Anyone ...

If you connect to SSIS with Object Explorer you can right click and select
View Logs. This will load the SQL Server Integration Services/NT Events into
a Log File Viewer. This log appear to go all the way back to the first time
that SSIS was installed and started. This can make ...