sql server dts: Importing from UNION queries in Access -- sql server dts

Re: Importing from UNION queries in Access

AlterEgo
2/27/2007 4:38:40 PM

sql server dts: Conan,

I don't believe union queries show up in the Table/View list. You should be
able to accomplish the same theng by clicking the SQL Query radio button and
pasting your query SQL code there.

-- Bill

[quoted text, click to view]

Importing from UNION queries in Access

Conan Kelly
2/27/2007 10:52:22 PM

Hello all,

Will DTS Packages *NOT* import from UNION queries in MS Access?

I have my Access & SQL Server (OLE DB Provider for SQL Server) connections
set up. I have my Transform Data Task going from Access to SQL Server. But
in the Source tab of the Transform Data Task Properties, my union query does
not show up in the Table/View drop-down.

Thanks for any help anyone can provide,

Conan Kelly