Error loading tables of different file groups.

Hi All,

I am facing a peculier problem. Problem definition goes like this,

I have one staging DB in which all the tables resides in Primary file and one production DB in which tables resides in 2 secondary files.

Now when iam trying to load the data from the table A in staging which is on primary file to the table A1 in production DB which in secondary file, all the data are going to error log instead of table A1.

Can you please tell me, where am i going wrong.

Regards,

Chetan

No. Not without the error message. Can you provide it?

-Jamie

|||

HI Jamie,

Sorry for that, error code and error message is as follows.

Error code:-1071607685

Error Message: No status is available.

Regards,

Chetan

sql

Error in Transfer SQL Server Object Task

Hi all,

I am facing problem while using Transfer SQL Server Object Task in SSIS, it is not importing table & its attributes.

The details settings of Transfer SQL Server Object Task as follows:
clicking edit - Objects(left pane)
Right pane
Connection
Source Connection existing server name 1
Source Database ganny1
Destination Connection existing server name 1
Destination Database ganny2
Destination copy objects
Objects to copy - copy all tables - true
Table Objects
CopyPrimaryKeys - True
CopyForiegnKeys - True

After setting all this configurations, Executing task, I am not able to get table in my destination database.
Please suggest me to solve the issue.

Thanks in advance
Karna

What is the value of CopySchema? If it's false, trying setting it to true.

Error in Stored Procedure while working with temp. table

Creating a temporary table in stored procedure and using a sql query to insert the data in temp. table.I am facing the error as :

String or binary data would be truncated.The statement has been terminated.

The procedure i created is as :

ALTER PROCEDUREfetchpersondetails

AS

CREATE Table#tempperson (personIDint,FirstNamenvarchar(200),LastNamenvarchar(250),titlenvarchar(150),Professionnvarchar(200),StreetAddressnvarchar(300),

StateAddressnvarchar(200),CityAddressnvarchar(200),CountryAddressnvarchar(200),ZipAddressnvarchar(200),Telephonenvarchar(200),Mobilenvarchar(200),

Faxnvarchar(200),Emailnvarchar(250),NotesPubntext,Affiliationnvarchar(200),Categorynvarchar(200))

Insert into#tempperson

SELECTdbo.tblperson.personID,ISNULL(dbo.tblperson.fName, N'') +' '+ISNULL(dbo.tblperson.mName, N'')ASFirstName, dbo.tblperson.lnameASLastName,

dbo.tblperson.honorASTitle, dbo.tblperson.titleASProfession, dbo.tblperson.street +' '+ISNULL(dbo.tblperson.suite, N'')ASStreetAddress,

dbo.tblperson.cityAScityaddress, dbo.tblperson.stateASstateaddress, dbo.tblperson.postalCodeASzipaddress,

dbo.tblperson.Phone1 +','+ISNULL(dbo.tblperson.Phone2, N'') +','+ISNULL(dbo.tblperson.Phone3, N'')ASTelephone,

dbo.tblperson.mobilePhoneASmobile, dbo.tblperson.officeFax +','+ISNULL(dbo.tblperson.altOfficeFax, N'') +','+ISNULL(dbo.tblperson.altOfficeFax2,

N'')ASFax,ISNULL(dbo.tblperson.Email1, N'') +','+ISNULL(dbo.tblperson.Email2, N'') +','+ISNULL(dbo.tblperson.Email3, N'')ASEmail,

dbo.tblperson.notesASNotesPub, dbo.tblOrganizations.orgNameASAffiliation, dbo.tblOrganizations.orgCategoryASCategory,

dbo.tblCountry.countryNameFullAScountryaddress

FROMdbo.tblpersonINNER JOIN

dbo.tblOrganizationsONdbo.tblperson.orgID = dbo.tblOrganizations.orgIDINNER JOIN

dbo.tblCountryONdbo.tblperson.countryCode = dbo.tblCountry.ISOCode

please let me know the solurion of this error.

What the error msg means is that you are trying to insert a value that is larger than what the column can take. Check your column lengths in the temp table and the data coming in from your SELECT statment. Apparently, you have crossed the limit somewhere.

|||

I made it working.Its not the column length that creating problem.

Error in reporting services

hi,

i am facing a problem in reporting services of Sql server 2005

i am trying to run the "third party tool"(Reports of proclarity) in sql server 2005

and i am getting the following error

An error has occurred during report processing.
Cannot create a connection to data source 'Employees_'.
Cannot connect to the server 'SYSTEM100'. The server is either not started or too busy.
Property name was not recognized, 'MDX Missing Member Mode'

regards

lalitha

This is a bit of a guess, since I don't really know much about how Proclarity works with Reporting Services, but given that 'MDX Missing Member Mode' is a valid connection string property that only appeared with AS2005 are you perhaps trying to connect to Analysis Services using an older version of the OLEDB for OLAP Provider? You should be using MSOLAP.3; if you don't have it installed, you can download it here:

http://www.microsoft.com/downloads/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en

Chris

|||

Hi Lalitha,

Check the connection string of your report (click the "Properties" tab and then select "Data Source" from the list on the left). Your connection string probably looks something like this:

Data Source=localhost;Initial Catalog=Adventure Works DW Standard Edition;Provider=MSOLAP;MDX Compatibility=2;MDX Missing Member Mode=Error

You need to change the "Provider" portion of the connection string from "MSOLAP" to "MSOLAP.3" so your connection string now looks something like this:

Data Source=localhost;Initial Catalog=Adventure Works DW Standard Edition;Provider=MSOLAP.3;MDX Compatibility=2;MDX Missing Member Mode=Error

Hope this helps,

Joe Hayes

Error in reporting services

hi,

i am facing a problem in reporting services of Sql server 2005

i am trying to run the "third party tool"(Reports of proclarity) in sql server 2005

and i am getting the following error

An error has occurred during report processing.
Cannot create a connection to data source 'Employees_'.
Cannot connect to the server 'SYSTEM100'. The server is either not started or too busy.
Property name was not recognized, 'MDX Missing Member Mode'

regards

lalitha

This is a bit of a guess, since I don't really know much about how Proclarity works with Reporting Services, but given that 'MDX Missing Member Mode' is a valid connection string property that only appeared with AS2005 are you perhaps trying to connect to Analysis Services using an older version of the OLEDB for OLAP Provider? You should be using MSOLAP.3; if you don't have it installed, you can download it here:

http://www.microsoft.com/downloads/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en

Chris

|||

Hi Lalitha,

Check the connection string of your report (click the "Properties" tab and then select "Data Source" from the list on the left). Your connection string probably looks something like this:

Data Source=localhost;Initial Catalog=Adventure Works DW Standard Edition;Provider=MSOLAP;MDX Compatibility=2;MDX Missing Member Mode=Error

You need to change the "Provider" portion of the connection string from "MSOLAP" to "MSOLAP.3" so your connection string now looks something like this:

Data Source=localhost;Initial Catalog=Adventure Works DW Standard Edition;Provider=MSOLAP.3;MDX Compatibility=2;MDX Missing Member Mode=Error

Hope this helps,

Joe Hayes

Error In Import

Hi all
I am Facing a Problem when Importting from Any database to SQL server2000 it gives me a read Error in Memory and Comes Out
Can any one help me ahy this happens
Thank (In Advance )Is it the same target database you're using when failing to import? If that's the case you need to do a health check on your db (BOL - DBCC CHECKDB(...))