I have been assigned to get an EDI written for enrollment of health insurance
from my HR system to a major insurance carrier; in fact, I need to create
about 5 Hipaa 834 files for other insurance companies too.  They want me to
send them data in a HIPAA 834 file format which I ...

We are new to SQL Server 2005.  When we import SSIS Package, there are 2
options - File System or MSDB file.
Which one should we choose ?
Thanks

During a project I gained a lot of knowledge of using the Theobald Xtract IS
DeltaQ component, which I like to share with you all.
I have written five blog entries on my blog that give a detailed explanation
of using the Theobald Xtract IS DeltaQ component

We have written a simple app that executes a simple DTS package constantly to
monitor memory. We were expecting to see memory usage maintained at the same
level as the package is not actually doing anything with the data, however we
are seeing a small, steady increase in memory ...

I'm trying to make a DTS package to update a field in SQL. This
package would run once per week or when a user forces it to run using
a batch file that contains DTSRUN.exe
The DTS package is should do this:

Client OS: Win2K
Client Excel Version: 2000
SQL Server: Version 7.0
I'm attempting to populate an Excel 2000 spreadsheet with

Whenever I paste in some Vba code from an ms access module it errors
on parts of the code that I have no problems with in Access.  I
couldn't find a references library in ssis and the script task
defaults to a sub procedure.  So I'm thinking maybe functions aren't

I'm a newbie in DTS's and Integration Services, but I need to migrate a DTS
to Integration Service but it's failing when i'm migrating the activex task
(in JScript).
I have the code below:

We have an Oracle database linked into a SQL Server.  Is it possible
to use SSIS to import a text file into a linked server?  Why don't we
just connect and import directly into the Oracle database?  Because I
can't get any connection to work within SSIS 2005.

I am running into an issue that no matter how I format the Prepare SQL
task, it puts a "_" in the tab name.
CREATE TABLE `Data Format`
Show up as Data_Format in Excel. This is for an automated process and

I am trying to use SSIS to import a text file into an Oracle
database.  However, I get the following error:
"Test connection failed because of an error in initializing provider.
Oracle client and networkinig components were not found."