Viewing 15 posts - 9,901 through 9,915 (of 13,874 total)
lnardozi 61862 (5/16/2013)
Just for completeness sake, you never use more than one UNION, which is the last one. All the rest should be UNION ALL.
Why not?
May 16, 2013 at 7:41 am
greeshatu (5/16/2013)
Its a Third party component [Kingsway]CRM DESTINATION ADAPTER [inserts data into Microsft CRM Dynamics]
If that's where the deadlocks are happening, can you ask them for support?
It would be...
May 16, 2013 at 4:28 am
What is 'CRM destination'? Is this a custom component?
May 16, 2013 at 3:37 am
Mordred (5/15/2013)
May 16, 2013 at 1:06 am
Can you answer a couple more questions about your set-up:
1) Is the file format the same for all files?
2) Is this a common staging table, or is there one staging...
May 15, 2013 at 12:58 am
Vikash Kumar Singh (5/14/2013)
What tool you are using to design packages? SSIS 2008/2008R2/2012.As per my experience you should always create environmental variables as System Variables.
First point to note is that...
May 15, 2013 at 12:51 am
You could try exporting from Excel to a CSV file and importing that. You'll have fewer problems, I assure you.
May 14, 2013 at 8:48 am
.. leaving you with a hanging package.
Nobody wants that 🙂
May 14, 2013 at 5:11 am
An important part of the error message: "There may be error messages posted before this with more information about the failure."
Generally, I've found that to be the case - so...
May 14, 2013 at 12:57 am
hewitg 82815 (5/13/2013)
May 13, 2013 at 8:58 am
ccmalls32 (5/12/2013)
Wonderful.
Share a website with you ,
Believe you will love it.
We accept any form of payment.
Spam reported again.
Please go away ccmalls.
May 12, 2013 at 10:22 am
There's a built-in function in C# that will do this without looping:
string col1 = "0001234";
col1.TrimStart('0');
May 12, 2013 at 9:39 am
Leep 63464 (5/10/2013)
hi juliehow did you fix it??
I think 'Jamie' was the name you were looking for 🙂
May 10, 2013 at 7:41 am
You could try something like this (untested):
Select HouseLine1 = (case when len(House_No_End) > 0 then House_No_Start + ' - ' + House_No_End
when len(House_No_Start) > 0 then House_No_Start
else House_Name...
May 10, 2013 at 4:01 am
How big is the file, roughly?
One option would be to pre-process it - maybe use s script task to replace "" with ".
If the file is huge, it might make...
May 10, 2013 at 2:06 am
Viewing 15 posts - 9,901 through 9,915 (of 13,874 total)