sql server dts: WHAT PROCEDURE/VIEW IS DTS USING FOR IMPORTING FLAT FILE -- sql server dts

Re: WHAT PROCEDURE/VIEW IS DTS USING FOR IMPORTING FLAT FILE

Allan Mitchell
9/28/2004 7:03:42 PM

DTS doesn't use any SP/VIEW or anything like that.

You could use BULK INSERT, BCP as well.

When you run a FLAT File import run profiler at the same time and you'll see
what it is doing

--

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

[quoted text, click to view]

Re: WHAT PROCEDURE/VIEW IS DTS USING FOR IMPORTING FLAT FILE

minimotorsport
9/29/2004 2:03:02 AM

Profiler just shows the DTS initializing.
Any idear how to get the SQL scripts that are used inside ?

Michael

[quoted text, click to view]

Re: WHAT PROCEDURE/VIEW IS DTS USING FOR IMPORTING FLAT FILE

Allan Mitchell
9/29/2004 8:30:57 PM

Look inside the packages themselves?

On the destination server you should still see the statements being issued
against the target tables.

--

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.