Size of content a DTS "Execute SQL Task" can hold

#1

What is the limit?

TIA

Quentin

#2

The ExecuteSQL task uses a BSTR.

HRESULT GetSQLStatement(BSTR *pRetVal);

HRESULT SetSQLStatement(BSTR NewValue);

A BSTR is comprised of a header, which includes information about the
length of the string, and the string itself, which may include embedded
nulls.A BSTR is limited to its length variable long which is of size
2,147,483,647

If I get mush bigger than the window I would generally call a script file
through OSQL

--
--

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:

What is the limit?

TIA

Quentin

#3

Thanks Allan.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

The ExecuteSQL task uses a BSTR.

HRESULT GetSQLStatement(BSTR *pRetVal);

HRESULT SetSQLStatement(BSTR NewValue);

A BSTR is comprised of a header, which includes information about the
length of the string, and the string itself, which may include embedded
nulls.A BSTR is limited to its length variable long which is of size
2,147,483,647

If I get mush bigger than the window I would generally call a script file
through OSQL

--
--

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 in message
news:%23yoCYvDlDHA.2432 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
What is the limit?

TIA

Quentin

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

Size of content a DTS "Execute SQL Task" can hold

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Size of content a DTS "Execute SQL Task" can hold - 10-16-2003 , 06:21 PM

Re: Size of content a DTS "Execute SQL Task" can hold - 10-17-2003 , 12:49 AM

Re: Size of content a DTS "Execute SQL Task" can hold - 10-17-2003 , 09:18 AM