Viewing 15 posts - 9,256 through 9,270 (of 13,876 total)
Jason-299789 (5/29/2014)
The Table that having an ALTER Column run against it is a 300 column heap...
May 29, 2014 at 5:28 am
How is your scripting?
If you put your results into an object variable, you can use a single script task to iterate around the results and do all the file manipulation...
May 29, 2014 at 5:23 am
hristo1977 (5/28/2014)
For some reason, the file had .txt.txt and my code was looking for .txt....
My guess would be that you'd chosen not to display known file extensions in Explorer -...
May 28, 2014 at 6:39 am
emps.txt.txt?
May 28, 2014 at 6:24 am
It's probably irrelevant, but do you realise that your variable is called 'FileExits' in the code, rather than 'FileExists'?
I'm running out of ideas, sorry. This is so simple, it should...
May 28, 2014 at 5:58 am
hristo1977 (5/28/2014)
Hi,Thanks for that. I got quite a few errors when pasting in that, do I miss a namespace?
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
using System.IO;
Regards
H
Looks like VB to me and...
May 28, 2014 at 5:49 am
Ryan Keast (5/28/2014)
Legend. Thanks Phil
No problem. And if you want to ignore the time component, you might like to use
dateadd(d,-7,cast(getdate() as date))
instead.
May 28, 2014 at 4:55 am
Yes - add it to the WHERE bit:
WHERE [existing conditions]
AND STAGE1.[STAGE.Completion_Date] > dateadd(d,-7,getdate())
May 28, 2014 at 4:51 am
Check the project properties under debugging and set 'Run 64 Bit Runtime' to false. Then try again.
May 28, 2014 at 3:21 am
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
Viewing 15 posts - 9,256 through 9,270 (of 13,876 total)