CODEWITHSUNDEEP
sqlssis
pramodtech
pramodtech

Reputation: 6280

SSIS oledb destination property OpenRowSet

What is significance of OpenRowSet property of oledb destination control in SSIS? My SQL admin has declared a new policy in which he says "Applications which use OpenRowset queries will not function." so I'm concerned about this whether my packages will work or not. Please advice.

Upvotes: 0

Views: 1876

Answers (1)

grapefruitmoon
grapefruitmoon

Reputation: 3008

Can you use SQL Profiler to check what is going on under the hood when your package runs? You should be able to see if it uses an OpenRowset query.

Upvotes: 1

Related Questions