January 3, 2012 at 8:14 am
Hi all, i have a question about a package in SSIS, i have an "OLE DB Source", then a "Row Count", then a "Data Conversion" and finally a "Table difference".
So, the thing is that in the "Table Difference" only appears the Input Columns of the "Data Conversion" and not the Output Alias. The Output Alias fields appears in the "Table Difference" but in the Warnings tab being ignored....
Thanks!
January 3, 2012 at 10:03 am
Error solved, the thing is that the input of the table difference are two data flows, from two differents DB, so for example, the field from database 1 is UserId and NewUserId, and the input of the other database is UserId, so in the tabla difference only appear the same name field (UserId) and not NewUserId.
See yaa
January 3, 2012 at 10:06 am
Glad you posted back with your findings.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply