March 14, 2012 at 11:48 am
Hello!
I have a column with uniqueidentifier datatype in sqlserver2000 table, I hav to perform a few functions based on that column n bringing that data in to sql server 2008 table(including the uniqueidentifier column). For this I have created a table in sqlserver2008 with the necessary columns and also included a column with the datatype uniqueidentifier. Now the problem is, when I am executing the query in management studio... it is giving me the column with the uniqueidentifier value (lets say the column name is scode_id). but when I am using the same query in "OLE DB Source".... there are only null values beinging displayed for the scode_id column.
The actual scode_id column values are some thing like this:
SCODE_ID
8FA29DFA-E5DC-4414-907E-8C153F737DA1
A631601D-1B7A-4968-9028-E7C9A352D543
8FA29DFA-E5DC-4414-907E-8C153F737DA1
A631601D-1B7A-4968-9028-E7C9A352D543
A631601D-1B7A-4968-9028-E7C9A352D543
--------------
I am getting the above values when I run the query in management studio.... but when I use the same query in SSIS Dataflow Task.... I get only null values for the scode_id column.
Can some one let me know where I am going wrong, or how to fix the issue?
I am using SSIS 2008.
March 15, 2012 at 2:05 am
Can you post the query?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply