Data Extraction Program within SQL Reporting Svcs

I have installed SQL Reporting Services and have been trying to implement the
Report Pack for SharePoint Portal Server that was recently released. Part of
the VERY limited instructions that comes with the Report Pack states that you
can import your existing SPS log files using the Data Extraction Program
(DEP).
I have tried this a number of times now and the SPS logs will import into
dbSPSReportingStaging with no errors. However, when the application attempts
to move those logs from dbSPSReportingStaging to dbSPSReporting I get an
error message "String or binary data would be truncated" and the statement
terminates without moving the data into dbSPSReporting.
Obviously (to me anyway) there is a field that is not of sufficient length
(or perhaps the wrong type) in dbSPSReporting. Given the fact that this DB is
created using a .sql script written and included in the Report Pack how can I
identify which field is causing the problem and fix it?
Any help is appreciated!
TIAMark Harrison pointed me to the link below which should fix the issue
http://blogs.msdn.com/dinod/archive/2005/08/19/453724.aspx
"Jay" wrote:
> I have installed SQL Reporting Services and have been trying to implement the
> Report Pack for SharePoint Portal Server that was recently released. Part of
> the VERY limited instructions that comes with the Report Pack states that you
> can import your existing SPS log files using the Data Extraction Program
> (DEP).
> I have tried this a number of times now and the SPS logs will import into
> dbSPSReportingStaging with no errors. However, when the application attempts
> to move those logs from dbSPSReportingStaging to dbSPSReporting I get an
> error message "String or binary data would be truncated" and the statement
> terminates without moving the data into dbSPSReporting.
> Obviously (to me anyway) there is a field that is not of sufficient length
> (or perhaps the wrong type) in dbSPSReporting. Given the fact that this DB is
> created using a .sql script written and included in the Report Pack how can I
> identify which field is causing the problem and fix it?
> Any help is appreciated!
> TIA

Data Connection problems - Database not found

I resently purchased a Virtual Windows 2003 Standard Server and I installed
SQL 2000 with Service Pack 3 on it to make sure it was up to date. I can ftp
on this server and everthing but when it comes to making a Microsoft ODBC
connection from my local computer to the virtual server I am not able to hook
up with it I recive a server time out is there something someone can be
patience with me and help me with this problem.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Can u connect using query analyser.?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23w2amiThEHA.1156@.TK2MSFTNGP10.phx.gbl...
> I resently purchased a Virtual Windows 2003 Standard Server and I
installed
> SQL 2000 with Service Pack 3 on it to make sure it was up to date. I can
ftp
> on this server and everthing but when it comes to making a Microsoft ODBC
> connection from my local computer to the virtual server I am not able to
hook
> up with it I recive a server time out is there something someone can be
> patience with me and help me with this problem.
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
|||How would I go about doing that .. I have tried to do the ODBC on my computer
setting up a SWL access to the computer and I still can't hit it..
"SKG" wrote:

> Can u connect using query analyser.?
> "SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
> news:%23w2amiThEHA.1156@.TK2MSFTNGP10.phx.gbl...
> installed
> ftp
> hook
> supports Post Alerts, Ratings, and Searching.
>
>
|||Okay when I ran the ODBC on the local server I found no problems
"Peter" wrote:
[vbcol=seagreen]
> How would I go about doing that .. I have tried to do the ODBC on my computer
> setting up a SWL access to the computer and I still can't hit it..
> "SKG" wrote:

Data Connection problems - Database not found

I resently purchased a Virtual Windows 2003 Standard Server and I installed
SQL 2000 with Service Pack 3 on it to make sure it was up to date. I can ft
p
on this server and everthing but when it comes to making a Microsoft ODBC
connection from my local computer to the virtual server I am not able to hoo
k
up with it I recive a server time out is there something someone can be
patience with me and help me with this problem.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.Can u connect using query analyser.?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23w2amiThEHA.1156@.TK2MSFTNGP10.phx.gbl...
> I resently purchased a Virtual Windows 2003 Standard Server and I
installed
> SQL 2000 with Service Pack 3 on it to make sure it was up to date. I can
ftp
> on this server and everthing but when it comes to making a Microsoft ODBC
> connection from my local computer to the virtual server I am not able to
hook
> up with it I recive a server time out is there something someone can be
> patience with me and help me with this problem.
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.|||How would I go about doing that .. I have tried to do the ODBC on my compute
r
setting up a SWL access to the computer and I still can't hit it..
"SKG" wrote:

> Can u connect using query analyser.?
> "SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
> news:%23w2amiThEHA.1156@.TK2MSFTNGP10.phx.gbl...
> installed
> ftp
> hook
> supports Post Alerts, Ratings, and Searching.
>
>|||Okay when I ran the ODBC on the local server I found no problems
"Peter" wrote:
[vbcol=seagreen]
> How would I go about doing that .. I have tried to do the ODBC on my compu
ter
> setting up a SWL access to the computer and I still can't hit it..
> "SKG" wrote:
>

Cyrillic problem with cr10 on XP and 2003

When I run my application on windows 2000 everything is ok. But on XP service pack 2 and windows 2003 words in report cut at the end of the line. Words a written in cyrillic alphabet. Does anybody meet this problem?Set Can Grow option for that field