May 4, 2010 at 3:58 am
Hi friends,
In have an SSIS package (2005) , it has an DataFlow task in which I have a OLEDB source and a Flat File destination.
In the OLEDB Source, Im using the DataAccessing mode as SQL command, and the command what Im giving is exec mysp @p1,@p2
It was working fine, now I have modified the SP so that it is returning two more columns, in SQL management studio if I run the sp for the parameter combination Im getting the result with new columns also. But the same is not getting refreshed in SSIS package.
In the OLEDB source when I click on the Column for mapping it is still showing the old set of columns.
How to refresh it?
Thanks & Regards,
MC
May 4, 2010 at 4:11 am
Hi Mithun,
This is unusual.Try building the solution file again.
Raunak J
May 4, 2010 at 4:38 am
You could try to refresh the metadata.
Instead of your old SQL statement, put
SELECT a = 1
This will wipe out your existing metadata. Then put pack your original SQL statement with the sp.
See if that works and let us know, I'm curious...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 4, 2010 at 11:45 pm
Hi Friend,
There was no luck with the above solution. (SELECT a = 1)
Thanks & Regards,
MC
May 5, 2010 at 2:21 am
Friends...
Its done, along with refreshing the OLEDB source , now I refreshed the Connection Manager, the it was reflecting.
Thanks & Regards,
MC
May 5, 2010 at 2:37 am
only4mithunc (5/5/2010)
Friends...Its done, along with refreshing the OLEDB source , now I refreshed the Connection Manager, the it was reflecting.
SSIS and metadata refreshing :unsure:
I hope they do something about it in a future release...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply