Viewing 15 posts - 9,271 through 9,285 (of 13,879 total)
Quick thought, escaped back-slashes?
Preceding the string with the @ avoids the need for that.
May 28, 2014 at 2:59 am
That's not right.
After setting a breakpoint in your code, close the code window.
At the package control flow, click on the execute icon. When the flow reaches the breakpoint, a VS...
May 28, 2014 at 2:46 am
hristo1977 (5/28/2014)
Hi,Well, I have tried. But when I set a break point and run debugging the VS software is always starting up (even though its already running). Is that normal?
Regards
H
It...
May 28, 2014 at 1:53 am
OK. are you debugging the actual script execution using breakpoints? Just to double-check the logic.
How are you inspecting the value of the variable?
May 28, 2014 at 1:43 am
hristo1977 (5/28/2014)
Newbie here regarding SSIS. I have a package that will check if a file exists in a folder. The user I use to run the SSIS is domain admin...
May 28, 2014 at 1:20 am
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
Viewing 15 posts - 9,271 through 9,285 (of 13,879 total)