Viewing 15 posts - 9,901 through 9,915 (of 13,879 total)
greeshatu (5/20/2013)
May 20, 2013 at 2:15 am
Your data comes in from Excel as Unicode.
If you are mapping it straight to varchar() columns, you will get an error.
Add a data conversion component to convert your columns from...
May 20, 2013 at 1:59 am
I couldn't find a way of doing this in an iTVF.
If you execute the following:
sp_executesql N'select * from products where name like @ProdName'
,N'@ProdName varchar(30)'
,@ProdName = 'Samsung%'
You'll get the idea of...
May 19, 2013 at 10:29 am
You could start by explaining what you mean by "not working."
Try rereading your message while imagining that you are not familiar with your environment. Do you think that you would...
May 17, 2013 at 2:03 am
Thanks Sean - that was the point that I was hoping to make.
May 16, 2013 at 8:16 am
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
Viewing 15 posts - 9,901 through 9,915 (of 13,879 total)