Viewing 15 posts - 9,271 through 9,285 (of 13,874 total)
There is a way. Have a look at the WITH RESULT SETS technique here.
May 27, 2014 at 2:40 pm
You may be suffering from 'parameter sniffing' - a quick search on Google will give you details of what that is and ways to get round it...
May 27, 2014 at 12:32 pm
venkat5677 (5/22/2014)
I done below steps:
I added first column from source to destination and executed I can able to send all records from flat file to OLE DB and second ,...
May 22, 2014 at 8:19 am
venkat5677 (5/22/2014)
May 22, 2014 at 7:31 am
Change the order of rows in the input file and then see whether it fails at the same place. Just moving the first 1000 rows to the end, for example,...
May 22, 2014 at 4:49 am
You could also try saving the contents of the Excel file to CSV and importing that.
If it still fails, you'll know that you have to focus your investigations on the...
May 16, 2014 at 12:01 am
Try sorting the data in the Excel file differently and see whether it still bombs out at the same place. That should indicate whether it's data or a setting somewhere.
May 15, 2014 at 10:54 am
PearlJammer1 (5/15/2014)
The other day a collegeue asked for a copy of dataload package that we use in SSIS. I right clicked the package and selected 'EXPORT' and...
May 15, 2014 at 10:10 am
twin.devil (5/14/2014)
venkat5677 (5/14/2014)
I changed destination table column length to 255 but no luck
What error you get this time? it should not be the same as the earlier one. but if...
May 14, 2014 at 11:56 pm
venkat5677 (5/14/2014)
I changed destination table column length to 255 but no luck
What do you mean? Was the warning message still this?
Truncation may occur due to inserting data from data flow...
May 14, 2014 at 11:55 pm
rhythmk (5/14/2014)
There are blank values or spaces in the columns in your source file.Better to TRIM or limit the length to certain number as per your requirement using SUBSTRING.
But this...
May 14, 2014 at 6:37 am
Phil Parkin (5/14/2014)
ronan.healy (5/14/2014)
how would the replace workREPLACE("Mountain Bike", "Mountain","All Terrain")
all my data comes in differently so wont no what it is all thats the same is the class
OK, I...
May 14, 2014 at 4:53 am
ronan.healy (5/14/2014)
how would the replace workREPLACE("Mountain Bike", "Mountain","All Terrain")
all my data comes in differently so wont no what it is all thats the same is the class
OK, I didn't know...
May 14, 2014 at 4:52 am
Have you looked at the T-SQL REPLACE command? It should help.
May 14, 2014 at 4:39 am
ronan.healy (5/14/2014)
Net Asset Value for Ignis Absolute Return Government Bond Fund . Class A GBP
Total Outstanding shares for Ignis Absolute return...
May 14, 2014 at 4:38 am
Viewing 15 posts - 9,271 through 9,285 (of 13,874 total)