Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbphoenix
Yak Posting Veteran
68 Posts |
 Posted - 2009-10-14 : 12:51:24
|
| I have an OLE DB Source that runs several queries. Some of these queries create temp tables. While in the OLE DB Source Editor I can preview the SQL and the results are correct. But when I run the package, it fails validation.Error: 0xC004706B at Data Flow Task, DTS.Pipeline: "component "OLE DB Source" (1131)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".Error: 0xC004700C at Data Flow Task, DTS.Pipeline: One or more component failed validation.Error: 0xC0024107 at Data Flow Task: There were errors during task validation.SSIS package "Package1.dtsx" finished: Failure.I know this has something to do with temp tables. When I open the OLE DB Source again and say yes to fix the metadata issue, the columns are now empty, so now I can't map my data conversion. Is there anyway to use a temp table? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-14 : 13:33:12
|
There is an article somewhere in google I have seen.The solution was like this:use a global temp table (that's with ##)create that ##temptable in a query window in ssms and don't close it.set delayValidation to true in your packageset something like useSameConnection or retainConnection to true in your package
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Temp Table