2 DTS questions

#1

Hi,

1. Size of content a DTS "Execute SQL Task" can hold
2. How can one make a "Transformation Data Task" accept an empty in flat
file?

TIA

Quentin

#2

Quentin,

You would probably be best served by posting this in the DTS newsgroup.

--

Andrew J. Kelly
SQL Server MVP

"Quentin Ran" <ab (AT) who (DOT) com> wrote

Quote:

Hi,

1. Size of content a DTS "Execute SQL Task" can hold
2. How can one make a "Transformation Data Task" accept an empty in flat
file?

TIA

Quentin

#3

Thanks Andrew.

Btw, I got an answer to q #2.

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

Quentin,

You would probably be best served by posting this in the DTS newsgroup.

--

Andrew J. Kelly
SQL Server MVP

"Quentin Ran" <ab (AT) who (DOT) com> wrote in message
news:OlWmfxClDHA.2272 (AT) tk2msftngp13 (DOT) phx.gbl...
Hi,

1. Size of content a DTS "Execute SQL Task" can hold
2. How can one make a "Transformation Data Task" accept an empty in flat
file?

TIA

Quentin

#4

And I have posted an answer to your #1 in the DTS NG.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Quentin Ran" <ab (AT) who (DOT) com> wrote

Quote:

Thanks Andrew.

Btw, I got an answer to q #2.

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote in message
news:e9pmJiDlDHA.372 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
Quentin,

You would probably be best served by posting this in the DTS newsgroup.

--

Andrew J. Kelly
SQL Server MVP

"Quentin Ran" <ab (AT) who (DOT) com> wrote in message
news:OlWmfxClDHA.2272 (AT) tk2msftngp13 (DOT) phx.gbl...
Hi,

1. Size of content a DTS "Execute SQL Task" can hold
2. How can one make a "Transformation Data Task" accept an empty in
flat
file?

TIA

Quentin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

2 DTS questions

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

2 DTS questions - 10-16-2003 , 04:30 PM

Re: 2 DTS questions - 10-16-2003 , 05:55 PM

Re: 2 DTS questions - 10-16-2003 , 06:19 PM

Re: 2 DTS questions - 10-17-2003 , 02:48 AM