Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi,

I am running a stored procedure which has local temp tables.
I am taking a DFT and in that taking ado.net source and access mode is sql command. I am getting error as "Error at Data Flow Task [ADO NET Source [226]]: System.Data.SqlClient.SqlException: Invalid object name '#Vtvoudedtds'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)"

Preview showing the result but columns tab is blank and in some times it is showing the above message.

Please look into this.

Thanks

What I have tried:

I changed the retain same connection as true.
delay validation true
Posted
Comments
CHill60 7-Aug-18 7:50am    
Is there a route through your task or through your SP that is bypassing creating the table? We can't see your code!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900