Hi

I got the mistake,

In another execution of package I got error in

ADate Column,

I changed the datatype from datetime to nvarchar(100) and imported the tabel to SQL

and in SQL I came...

Yes I too think there is a much simpler way

for example using extended attributes of the...

AndyD (2/9/2009)

---

A basic test would be to import a table from an Access DB, which you have created to include the columns and data that you want to check.

In MSSQL...

Hi Andy, this is what I needed.

Some tests in the sense which kind of test?

How can...

AndyD (2/9/2009)

---

I'm sure there are docs out there to help with importing from Access. I haven't done it for a while, so I created a demo table in Access 2003...

AndyD (2/6/2009)

---

As you have to EXEC a snippet of SQL code (hmmm, unless you updated the schema tables directly....), probably easier to run this in a Cursor. May not be...

Yes Andy,

I am doing the same...

Can you tell...

yes this will do for the table given.

but what if the ntext column is in different position?

I am trying to...

Michael Earl (1/30/2009)

---

Without defining "correctness" there is little to tell you.

SSIS and MSSQL will verify that your data matches the data types in your desintation table and error if the...

Hi,

I just linked the access table to SQL Server 2005

exec sp_addlinkedserver @server='AccessDb',

@srvproduct='Access',

@provider='Microsoft.Jet.OLEDB.4.0',

@datasrc='C:\TEMP\csd.mdb'

exec sp_addlinkedsrvlogin @rmtsrvname='AccessDb',

@useself='false',

@rmtuser='Admin',

@rmtpassword=''

I can see the tables and views in the access using

sp_tables_ex 'AccessDb'

and see...

I think the link is

http://msdn.microsoft.com/en-us/library/ms143761(SQL.90).aspx

All the features are listed here for all editions

Thanks

Ramesh (1/16/2009)

---

Actually, something has ate-up my code....:D:D, missed the table in LEFT JOIN....

its wrking used the same query olny retrived distinct...

Abhijit More (1/16/2009)

---

its wrking used the same query olny retrived distinct records from tmpPoj..:)

SELECT tmp.PojID, tmp.Cat,

...

Abhijit More (1/16/2009)

---

here's your answer...

DROP TABLE tmpPoj

DROP TABLE tmpCat

CREATE TABLE tmpPoj

( PojID INT, Cat VARCHAR(10), Total INT )

CREATE TABLE tmpCat

( CatIDINT, Cat VARCHAR(10) )

INSERTtmpPoj

SELECT1, 'A', 1 UNION

SELECT1, 'B', 2 UNION

SELECT2,...

Chirag (12/23/2008)

---

Hi

Iam afraid you will have to write your own storedproc/ trigger. I cant do that for you. If you know oracle then doing it in SQL should not be...