importing trace data into table...

I follow the instructions to import text data from the link below:
http://support.microsoft.com/default...b;en-us;270599
but when i look at the trace_table, in the columb textdata, it's
NULL... where can i find the content?
Infact, the only columns that have data, is SPID, servername,
eventclass all other columns are NULL...
any help?
Tascien wrote:
> I follow the instructions to import text data from the link below:
> http://support.microsoft.com/default...b;en-us;270599
> but when i look at the trace_table, in the columb textdata, it's
> NULL... where can i find the content?
> Infact, the only columns that have data, is SPID, servername,
> eventclass all other columns are NULL...
> any help?
Did you include the textdata item in the trace? Was this a server-side
trace or are you saving a trace from Profiler?
David Gugick
Imceda Software
www.imceda.com
|||D'uh!
I missed that. yes, i did not include TextData in the columns...
thanks.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message news:<eyBlPXd1EHA.1408@.TK2MSFTNGP10.phx.gbl>...
> Tascien wrote:
> Did you include the textdata item in the trace? Was this a server-side
> trace or are you saving a trace from Profiler?
sql

importing trace data into table...

I follow the instructions to import text data from the link below:
http://support.microsoft.com/default.aspx?scid=kb;en-us;270599
but when i look at the trace_table, in the columb textdata, it's
NULL... where can i find the content?
Infact, the only columns that have data, is SPID, servername,
eventclass all other columns are NULL...
any help?Tascien wrote:
> I follow the instructions to import text data from the link below:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;270599
> but when i look at the trace_table, in the columb textdata, it's
> NULL... where can i find the content?
> Infact, the only columns that have data, is SPID, servername,
> eventclass all other columns are NULL...
> any help?
Did you include the textdata item in the trace? Was this a server-side
trace or are you saving a trace from Profiler?
--
David Gugick
Imceda Software
www.imceda.com|||D'uh!
I missed that. yes, i did not include TextData in the columns...
thanks.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message news:<eyBlPXd1EHA.1408@.TK2MSFTNGP10.phx.gbl>...
> Tascien wrote:
> > I follow the instructions to import text data from the link below:
> >
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;270599
> >
> > but when i look at the trace_table, in the columb textdata, it's
> > NULL... where can i find the content?
> >
> > Infact, the only columns that have data, is SPID, servername,
> > eventclass all other columns are NULL...
> >
> > any help?
> Did you include the textdata item in the trace? Was this a server-side
> trace or are you saving a trace from Profiler?

Importing data from DB2 to SQL server

Hi,

I'm new to SQL server. My huge data is there in DB2. I tried to import using SSIS import/export wizard, it does successfully with default datatype columns.

for example, If my DB table has numeric columns, it has been imported as "double" and if it is string, it has been impoerted as "nvarchar". Is there any way to have correct/equivalnet datatype import from DB2?

Rgs

Vasu

You could save the package generated by the export/import wizard and then modify it as you need. Take a look at the data convertion transformation in the data flow. Here are some SSIS data types guidelines:

http://msdn2.microsoft.com/en-us/library/ms141036.aspx

|||I don't understand. The data types seem correct to me. What's the problem exactly?

DB2 data types are not necessarily the same as SQL Server.|||

This page has tables of data type mappings between DB2 and SQL Server:

http://www.redbooks.ibm.com/redbooks/SG246672/wwhelp/wwhimpl/common/html/wwhelp.htm?context=SG246672&file=23-2.htm

You can download the larger documentation from which this is taken (in PDF format) here:

http://www.redbooks.ibm.com/redbooks/pdfs/sg246672.pdf