Hi,

I could not access the MS Access system tables from SSIS.

Hi Thanks for your reply.

I tried the way you said :

Set View-- >Options/ General/Show System objects to "yes".

When I set that I could only see those system objects in MS...

Hi Thanks for your reply. It has to be a SSIS package..We are taking each table and comparing with another table in the database. Since comparison cannot be done in...

yes the resultset property is set to none

HI Tim,

I'm receiving the following error

exec(@sql)" failed with the following error: "Parameter name is unrecognized.". Possible failure reasons:...

Hi can you explain it in detail how to pivot it

Hi Thanks a lot for your reply...If the format is not the same that is if the order of the columns is different then how can we reference the file...

so wht do i need to do now..do i need to commit or rollback the transaction in the catch block?

Hi Barry,

The database owner SID recorded in the master database differs from the database owner SID recorded in database ''....

Hi,

Thank you very much...that worked out for me.

Hi Barry,

CREATE QUEUE [dbo].[]

WITH

STATUS = ON ,

RETENTION = OFF ,

ACTIVATION

(

STATUS = ON ,

PROCEDURE_NAME = [dbo].[] ,

MAX_QUEUE_READERS = 1 ,

EXECUTE AS...

Hi i've seen the below error in the SQL Server error logs

error:

The activated proc [dbo].[] running on queue x output the following 'Cannot execute as the database prinicpal because the...

Hi,

i'm getting an error with the principal 'dbo'. It says 'dbo' doesn't exist or i dont have permission

I tried changing it to SELF. But again it...

Hey Barry sorry for that. I thought you did not see that message over there. please dont mind

Hi Barry,

Where can we see the created Master Key in Sql server Management Studio?

Or how to know whether the...