I have a DTS package that reads a text file. The delimiters are tab for
columns and {CR} for rows. When I import the file with the DTS, the job
seems to run successfully but no rows are added to the table.

I have checked the text file and they are rows in the text file. There are
no indexes on the table. There are no views or indexed views accessing the
table either.

Any assistance would be much appreciated.

Thank you in advance.

Stacy,

Try using bcp utility instead. I had the same issue and simply switching to
bcp resolved it. Besides, you have ability to specify error and output
files.

Ilya

"Stacy Hein" <sthein5 (AT) rockwellcollins (DOT) com> wrote

Seeing as you are using BULK INSERT task what happens when you define the
statement in QA?
What does your statement look like?
Can you use a simple Transaform Data Task?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Stacy Hein" <sthein5 (AT) rockwellcollins (DOT) com> wrote