Viewing 15 posts - 8,896 through 8,910 (of 11,676 total)
Are you sure all values of the V_Version column can be converted to integers?
November 2, 2011 at 1:17 am
At first glance, you didn't miss anything.
Enable logging and try to find out if there are any configuration messages.
If you run the package in BIDS, do you have any warnings/erros...
November 2, 2011 at 1:08 am
Thomas.s (10/31/2011)
ya thanks..just i need empno1.sal -empno2.sal in ssis map.i dont want less than current value etc
What exactly do you mean with "ssis map"?
November 2, 2011 at 12:56 am
Nice question. It was tempting to select FOR, AFTER, INSTEAD OF :-D.
November 2, 2011 at 12:42 am
Add more RAM to your machine?
Or design your dataflow a bit better so that it doesn't consume so much memory.
What are you trying to do?
October 31, 2011 at 3:18 am
Is there any business rule that says which salaries should be subtracted by other salaries?
Or is it just random?
Since you are trying to compare rows with each other (which is...
October 31, 2011 at 3:17 am
For .xlsx you need to use the ACE OLE DB provider. Normally this is automatically selected when you choose Excel 2007 in the Excel Connection Manager.
Also make sure you are...
October 28, 2011 at 12:55 am
I forgot:
if the result of the query is huge, you'd be better off with importing each table seperately and then join in SQL Server itself. Using the dataflow will result...
October 28, 2011 at 12:52 am
Your solution should work, but make sure to put an ORDER BY on the join columns and mark the input as sorted in the advanced editors of the sources, as...
October 28, 2011 at 12:49 am
Since it is some sort of XML specification for Excel, maybe try a XML Source?
October 28, 2011 at 12:47 am
Please do not crosspost.
It wastes people's time and fragments replies.
Original post with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1197301-391-1.aspx
October 28, 2011 at 12:46 am
Viewing 15 posts - 8,896 through 8,910 (of 11,676 total)