Viewing 15 posts - 871 through 885 (of 4,272 total)
Have you tried setting the max errors to some crazy number like 1000000? Not sur eif that will give you what you are looking for.
CEWII
October 26, 2011 at 9:06 am
Jeff Moden (10/25/2011)
Gah! Sorry for my last, Elliott... I didn't scroll down far enough.
I was about to say *cough*look harder, its there*cough*
CEWII
October 25, 2011 at 8:14 pm
The value of the variable is unimportant, just so that you can tell that what is there by default is NOT there at run-time. Use some simple text for...
October 25, 2011 at 4:16 pm
By default the package will show a warning and the default value will be used. It will not die.
If you use the code I have specified it will die.
Beyond...
October 25, 2011 at 3:32 pm
Also, you need to click on the Script Task in the Control Flow and look at its properties, look for the property that is FailPackageOnFailure, by default it will be...
October 25, 2011 at 3:09 pm
If it cannot get the value from the environment it will not be NULL it will be the default.
In this case you can't know if it failed to get the...
October 25, 2011 at 3:08 pm
kiran23330 (10/25/2011)
Thanks for the reply...The Envi variable is having connection string of server and database ..
can You explain me in detail..am not familier with script task...
Add a script task...
October 25, 2011 at 2:32 pm
Double click on the line connecting the source from the derived column, it will tell you what the data type coming out of the source is, you might have to...
October 25, 2011 at 2:09 pm
Evil Kraig F (10/25/2011)
kiran23330 (10/25/2011)
Can Any one tell me how to force the package to fail when it is not found Envi variable???
Unfortunately no, but I can give you a...
October 25, 2011 at 2:06 pm
Evil Kraig F (10/25/2011)
Elliott Whitlow (10/25/2011)
I am very glad it worked out for you but I would strongly encourage moving away from linked servers in nearly all cases.CEWII
I'm afraid I'll...
October 25, 2011 at 2:04 pm
There is no explicit setting that I know of and the system will just generate a warning. HOWEVER, you could add a Script Task at the very start of...
October 25, 2011 at 1:59 pm
The value needs to be of a character type so you can do a derived column on the text value NA. I'm guessing it is failing at the source,...
October 25, 2011 at 1:40 pm
I am very glad it worked out for you but I would strongly encourage moving away from linked servers in nearly all cases.
CEWII
October 25, 2011 at 1:38 pm
Have you traced it to see what is actually being sent to the database?
CEWII
October 25, 2011 at 9:41 am
Jeff Moden (10/24/2011)
Elliott Whitlow (10/24/2011)
October 24, 2011 at 4:39 pm
Viewing 15 posts - 871 through 885 (of 4,272 total)